Forum Discussion
PowerBITestingG
Resolver I
Resolver ITransform 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 in...
AntonioM
Solution Sage
Solution SageYou 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.
PowerBITestingGWhich 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