Forum Discussion
How to Extract a 2-Column List from a Table
Above is a sample of the table I am trying to extrapolate from. To simplify what I am looking to do, is I want to create a list of every item in Columns 3+ with its associated Date in Column...
Since you're already using PQ to cleanup the data, I propose a PQ solution to finish with an unpivot and some light cleanup.
- So two new questions.
Is there a way to filter so it only takes the first Date an Item is present, removing future duplications of that item from the list?
And is there a simple way to filter so that each Item prefix gets its own column? i.e. 'WT' Items are separated into a new column from 'FS' Items and so on? - Oh, I tried the Pivot to see if it would give me something to work with, but I have not seen the Unpivot. PQ is a very new tool to me. Hahah
- This is a good resource for unpivoting in PQ. I used 'unpivot other columns' in this example.
https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098
