Pivot groups of rows into columns group by

[dpombal]

Hi all,

I am reading an XML file with this shape

Using Power Query to Expand Label table (??Is it possible to expand and create 3 columns...instead 3 rows)

  #"ExpandLable" = Table.ExpandTableColumn(Table0, "label", {"group", "text"}, {"label.group", "label.text"})

And Data is converted in this format... after expanding

Now I have data with this format ( in colours by group)

However now I need to get converted data in this format, in each group of 3 registers by Instance ID.

ID, start,end, code ,pos_x and pos_y are always the same value inside a group.

I tried several pivoting options with no ...luck

Regards

[v-jiascu-msft · Accepted solution]

Hi @dpombal,

Please refer to the snapshot below. 

1. Select the two columns "label.group" and "label.text".

2. Follow the steps in the snapshot.

Best Regards,
Dale