Changing from a flat data structure to a stacked data structure - MS Excel

Concern Support
Concern Support used Ask the Experts™
on
Hi,
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

Thanks,
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial