Forum Discussion
Transposing from columns to rows
Hi Michelle,
Creating varying numbers of columns for each of your names would be a pain. If you just want to condense your table to one row per [App Group Name], but retain all the [Description] information, then I'd group the table on [App Group Name] and add a description aggregatd column using the SUM operator. This will give you an error initially, but will give you the code structure in the formula bar, where you can replace the SUM section with Text.Combine, something like this:
// Change this:
Table.Group(previousStepName, {"App Group Name"}, {{"Description", each List.Sum([Description]), type nullable text}})
// to this:
Table.Group(previousStepName, {"App Group Name"}, {{"Description", each Text.Combine([Description], ", ")}})
Pete
Thank you Pete, that has worked for and saved me a lot of time.
I don't know what I have done, but done a fresh one and just cannot group it, I wont give me the 2nd column in the grouping
Help!
Michelle.
Hi Michelle,
Not sure what the question is here.
If you select your [App Group Name] column, go to the Home tab > Group By, then add a SUM aggregated column on your [description] column that should get you back to where you can swap out the code as before.
Pete
In the group by, it is not letting me click on the drop own for the sum and on the column dropdown it wont open up for me to select Description column