shaharbiras
New Member
- Joined
- May 30, 2019
- Messages
- 3
Hi,
I have a large dataset with 2 columns -
first column is name and can have duplicate values (any amount of duplicates)
seconds column is id and can also have duplicates
I want to pivot the table in that way -
first column will have a distinct value of the name followed by the corresponding id's per name
in example I want to turn this-
a 1
a 2
b 3
c 3
c 4
c 5
into this -
a 1 2
b 2
c 3 4 5
I would prefer to use Power Query/Pivot in the solution if possible since I deal with very large data sets
I have a large dataset with 2 columns -
first column is name and can have duplicate values (any amount of duplicates)
seconds column is id and can also have duplicates
I want to pivot the table in that way -
first column will have a distinct value of the name followed by the corresponding id's per name
in example I want to turn this-
a 1
a 2
b 3
c 3
c 4
c 5
into this -
a 1 2
b 2
c 3 4 5
I would prefer to use Power Query/Pivot in the solution if possible since I deal with very large data sets