I have a requirement for an excel sheet to be formatted from a flat structure to a stacked structure. I'll try to explain:
In the flat structure has a number of basic columns, some of these columns repeat multiple times ('Transaction1', 'Transaction2', 'Transaction3'). some of the items will not have all transaction data, therefore some of those columns may be blank for a given item.
Example - https://imgur.com/B3h4Iir
I need to take this data structure and transform it in another sheet/workbook so it goes like this. The transaction is a single column with the transaction1,2,3 data repeating as row beneath the item, all other columns will remain blank. The next item will begin on the next available blank row.
Example - https://imgur.com/x8f2c4T