September 16, 2021
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.
P.S. size constraints are preventing me uploading what I currently use to do this
July 16, 2010
Welcome to our forum!
In the attached file I've added a conditional column for the name that appears above each section. It's not clear what else you wanted done as there wasn't a 'desired result' example, but hopefully that gets you started.