Hello there,
Been a while since I've been on here. Hoping I can tap into your expertise.
I've been given a task where I need to convert one dataset to be formatted similarly and merged with another dataset. I've almost managed to get there using the unpivoting functionality of power query - I can handle the multiple header rows, but the repeating columns are defeating me.
I've attached sample data - essentially I need to get the data in the 'Table' sheet to look like the data in the 'Excel' sheet. I know about filling the gaps in the column A during the process. And also that Product Code, CustomerKey and Product Name will be static rows. I'm not sure how to account for the the repeating Quantity, Unit Cost and Sales Amount columns.
I'd be very appreciative if someone could guide me through the process.
Cheers,
TRC
Bookmarks