Forum Discussion
Transform duplicate rows into columns
Hello,
So basically I got a table with 2 columns, the Type column can contain many different values
| Name | Type |
| a | Trek |
| a | Agrek |
| b | Grob |
| b | Job |
So I need to split them into this:
| Name | Type1 | Type2 | Type3-99 |
| a | Trek | Agrek | etc |
| b | Grob | Job | etc |
Any ideas? I am stuck
2 Replies
You could do it in Power Query. First, you'd want to use Group by to concatenate the text values.
= Table.Group(#"Source", {"Name"}, {{"Type", each Text.Combine([Type], ","), type nullable text}})Then you could split that by the commas
= Table.SplitColumn(#"Grouped Rows", "Type", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), {"Type.1", "Type.2"})Which should give you
That should give you as many columns as you need. If a name gains more types, you'd need to ok the split column step again.
Which should give you
That should give you as many columns as you need. If a name gains more types, you'd need to ok the split column step again.
Thats the issue I am trying to solve, I cant know how many they are the data set is too big and it keeps changing
