Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I'm fairly new to Power BI and struggling with an Excel data source that isn't laid out in the format I require. I'm using Power BI Desktop and have had a play around with the Edit Queries / Transform data function to no avail. Hoping there is a simple method to manipulate the data!
Data is currently set out as follows...
I would like the data to be set out in a format as follows..
... and so forth.
Any help would be much appreciated!
Thanks,
Stuart
Solved! Go to Solution.
Hi @Stu_22 ,
In Power Query, select your [Inspection] column, then go to Transform tab > Unpivot Columns (dropdown) > Unpivot Other Columns.
This should do what you want.
Pete
Proud to be a Datanaut!
Thanks very much Pete - that's worked a treat!
Regards,
Stuart
Hi @Stu_22 ,
In Power Query, select your [Inspection] column, then go to Transform tab > Unpivot Columns (dropdown) > Unpivot Other Columns.
This should do what you want.
Pete
Proud to be a Datanaut!