Aligning value and associated fields to match another column, with new rows created if needed.

namy77

New Member
Joined
Apr 19, 2016
Messages
26
Good afternoon,

In the spreadsheet, which was populated by tableau, the quantity break and its associated price from the last record and those from the previous record do not line up. Is there anyway we can match values in column P, along with the prices in column O to values in column N? If there are breaks in column P that don't exist in N, they should be lined down to create new break NO, but still under the same attributes for column B to F.

Thanks!
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Threads
1,108,951
Messages
5,525,846
Members
409,667
Latest member
jwieting

This Week's Hot Topics

Top