Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
93
Views
Topic starter
Not sure how to explain I am extracting data from pdf (again) the top row contains depot and purchase order number I have split them out transposed duplicated retransposed etc but I cant see how to get the PO to match depot and product tried all variations of pivot unpivot the closest I get to what I need is in the 2nd screenshot. but I need row 121-130 included as an attribute not a value.
John
Posted : 06/01/2021 7:43 am
Hi John,
There is no attachment, please try again.
Posted : 06/01/2021 11:18 pm
Topic starter
Its OK I puzzled it out simply promoted headers before splitting into depot and PO then unpivot and split
Posted : 07/01/2021 7:16 am
