Hi there, I have a table of data from a query containing listings of one entry for each issue date of a document. I want to merge this into one entry of each document containing every issue dates in the following columns.
From this:
Document ID Date
34304 23.11.2011
34304 24.03.2012
34305 23.11.2011
34305 24.03.2012
34305 26.03.2017
34306 23.11.2011
Into this:
Document ID Date-1 Date-2 Date-3 ... Date-n
34304 23.11.2011 24.03.2012
34305 23.11.2011 24.03.2012 26.03.2017
34306 23.11.2011
Is there an easy way doing this in Power Query, alternatively a VBA code.
In advance thanx.
Hi Aslak,
I would just use a PivotTable to do this. In the file attached there is the PivotTable solution and the Power Query solution. It's up to you which one you use.
Mynda
Hi
Just a slight variation to Mynda's PivotTable solution.
This will ensure that all dates begin in the 1st column and so on without any blanks in between.
Hope this helps.
Sunny
Please refer to attached file with a helper column.
