How to combine multiple rows in to columns

[RobHaigh]

Trying to get my head round Dynamics 365 Finance and Operations and Power BI.
Finance and Operations holds product data and each product can have multiple attributes against it.
Due to the way Finance and Operations stores the data it looks initially like this.

ProductCode	AttributeName	TextValue
10000	Size	5
10000	Finish	Matt
10000	Hex	ABCDE
20000	Size	2
20000	Finish	Gloss
20000	Hex	DEFGH
30000	Size	Roll
30000	Length	6
30000	Match	Full
30000	Washable	Yes

For ease of reporting in Power BI I would like to transform it to look like this.

ProductCode	Size	Finish	Hex	Length	Match	Washable
10000	5	Matt	ABCDE
20000	2	Gloss	DEFGH
30000	Roll			6	Full	Yes

I am a bit stuck / end of my knowledge / patience   🙂

Cant get it to work.....

Anyone got any ideas?

[RobHaigh]

Pete, Many thanks, saved me a ton of head scratching 🙂

[BA_Pete · Accepted solution]

Hi @RobHaigh ,

In Power Query, select your [AttributeName] column, go to the Transform tab > Pivot Column and set up the dialog like this:

...to get this output:

Pete