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?
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?