Forum Discussion
Pivot text to table
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
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!
Sean, not sure what error you are referring to? I was simply trying to answer the question as asked