Unpivot MYOB report with irregular titles|Power Query|Excel Forum|My Online Training Hub

Hi Myanda

I posed this question against your youtube video - Power Query Unpivot - fix 4 common data layouts tutorial. I am trying to query MYOB reports that do not have uniform repeating rows but, similar to the 4th example, I need the header row to the block of rows in its own column for each row of data. For example, I download the Activity Slip [Employee Detail] for a period and then need to extract how much time has been spent on various jobs over that period. Presently, I have a series of helper columns to clean up MYOB's mess; not sure if there are ways of unpivoting that. I’ve attached a de-identified copy of the MYOB report and the workbook I’ve developed to extract the data I’m after in this instance – identifying the costs of jobs or work we’ve done for clients for the month.

Thanks Andrew

P.S. size constraints are preventing me uploading what I currently use to do this