Transform Data from rows to columns

Question

Hi,&nbsp;&nbsp;is it possible to transfrom some table from these structure:ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Attribute4711&nbsp; &nbsp; &nbsp; A4711&nbsp; &nbsp; &nbsp; B4712&nbsp; &nbsp; &nbsp; A&nbsp;in the following result:ID&nbsp; &nbsp; &nbsp; &nbsp;Attribute4711&nbsp; &nbsp;A|B4712&nbsp; &nbsp;A&nbsp;Thanks for youre help!

slorin · Accepted Answer

Hi&nbsp;Anonymous&nbsp;
Group by ID, choose Sum and replace List.Sum by Text.Combine(&nbsp; , "|")
= Table.Group(Source, {"ID"}, {{"Attribute", each Text.Combine([Attribute], "|"), type text}})
&nbsp;
&nbsp;
Stéphane&nbsp;

Forum Discussion

Transform Data from rows to columns

2 Replies

Related content

Transform columns / type

Data transform using power query

Eventhouse data transformation

Data Transformations

Table Transformation