Creating template file, data is mismatch in rows.

[Paulie752]

Sample WB For Template.xlsx

Raw data being pulled occupies multiple rows and columns and instead of aligned in one making difficult to return ideal value. Attached sample data to post. Attempted multiple methods to isolate and display as ideal.

Data lives between columns A through P. Targeting lines not equal to "Adjusted" in column P, but Parent "Sales Order" info can be dynamic as it can be located 2-8 rows above within column A.

Im out of ideas in making this work without using VBA or manipulating the source data.

[AliGW]

Welcome to the forum.

So what's the logic? How do you know which codes and descriptions go together? I wouldn't have the first idea about why you've pulled and matched the ones you have on the right.

More detailed explanation required, please.

[Paulie752]

Thank you!

The only logic is the Sales Order is displayed prior to the actions being reported. I previously attempted a lookup or xlookup in attempt to factor in the hierarchical nature by avoiding the other data existing within column A ie "AGCD, CCGC, and APID". Also attempted to use Offset but due to the inconsistent value of the multiple actions that could occur proved to be a bust. example formula =CHOOSECOLS(FILTER(Sheet1!A:T,(Sheet1!P:P<>"Adjusted")*(Sheet1!P:P<>"")),1,2,7,16,20) As row in 22 through 27, through the filter new row 3 would display correctly, but Row 4 and Row 5 would display "AGCD" instead of DEF5678.

[AliGW]

Explain how I would:

1. Identify what is and what isn't a sales order.
2. Work out which action applied to any identified sales order.

You know your data intimately - I don't.