Is it possible to do a Pivot Text Table, with PowerQuery ? ContentType --->HeaderVotesCommentStatusPivot tables and breakdown treesHeader Pivot tables and breakdown trees6,50562 commentsstarted6,505Votes Custom branding/colour scheme of dashboard (custom css?)3,08566 commentsstarted62 commentsComments send report or dashboard as email3,536106 commentsstartedstartedStatus Refresh dashboards tiles when i change a report39521 commentsstarted

Ola It seems you need an additional column like in the picture (I've named it Idea Number) and then it works :smileyhappy:

Pivot text to table | Microsoft Fabric Community

Resident Rockstar

There is a Pivot transformation in Power Query, see the steps below

Raw Data

Select Pivot Transform

select the column that contains the headers to pivot

-> select Pivot transform from transform ribbon

-> select advanced and choose no aggregation

Transformed Data

Community Champion

richbenmintz I think Ola should have posted this a sample data set based on the desired output

Content	Type
Pivot tables and breakdown trees	Header
6,505	Votes
62 comments	Comments
started	Status
Custom branding/colour scheme of dashboard (custom css?)	Header
3,085	Votes
66 comments	Comments
started	Status
send report or dashboard as email	Header
3,536	Votes
106 comments	Comments
started	Status
Refresh dashboards tiles when i change a report	Header
395	Votes
21 comments	Comments
started	Status

That's when you get the error!

richbenmintz
Resident Rockstar
9 years ago
Sean, not sure what error you are referring to? I was simply trying to answer the question as asked

Content	Type	--->	Header	Votes	Comment	Status
Pivot tables and breakdown trees	Header		Pivot tables and breakdown trees	6,505	62 comments	started
6,505	Votes		Custom branding/colour scheme of dashboard (custom css?)	3,085	66 comments	started
62 comments	Comments		send report or dashboard as email	3,536	106 comments	started
started	Status		Refresh dashboards tiles when i change a report	395	21 comments	started