Unpivot

[Jos13]

Hi Team,

I have a data with the following structure.

I unpivoted the columns as follows,

then I split the Attribute column by number of characters

Next I did pivoting the Attribute 1 column with Value column which gave me the following table.

The expected table should only contain 2 rows. Can anyone please explain what did go wrong ? 

Thanks,

Jos

[v-easonf-msft · Accepted solution]

Hi, @Jos13 

Can you show me  the  result you want?

If this is the expected result your want ,you can check if the following sample file helps.

pbix attached

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Jos13 , your post is not complete.

for unpivot refer

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/