I have an Excel spreadsheet that has sections going across with common fields (columns) in each repeating section. I would like to transform the data into a single dataset of records with the common fields aligned. I have seen posts about sections that are arranged in rows going down, but I have not found any posts on sections that repeat across in columns.
I have attached some random data arranged in the manner in which the sections repeat. I only created four repeated sections for the example, but the original file has many more sections going across.
Here is the layout of the input (see attached Excel file):
Here is the desired output:
Thank you in advance for any help with an efficient approach to this scenario.
