Hi,
I am new to Power Bi but it seems to be able to do most of the manipulating tasks I need for a monthly task I need to perform.
I have a file that I need to manipulate, it has section headers and I would like these to be listed as a new column at the end of each applicable row.
I have attached a sample raw data file and a (manually) manipulated end result file.
Can Power BI do this for me please?
thanks
Sharon
Hi Sharon,
Welcome to our forum!
You can use Power Query inside of Excel or Power BI to clean this data. See Query 1 in the file attached.
If you'd like to learn Power Query, please consider my Power Query course.
Mynda
Hi Mynda,
that's great - thank you so much, it works a treat.
My manager now thinks I'm a wiz, serious brownie points earned. so thank you
kind regards
Sharon
