Convert Repeating Sections of Columns in Excel Tab (Same Column Headings in Sections)

[taxtechfl]

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.

[Qiu · Accepted solution]

@taxtechfl 
I think this one should work as dynamic for more sections.

[taxtechfl]

Thank you so much, @Qiu , for the solution and for developing and posting it so quickly.  I truly appreciate it.  You solved this with very few steps; that's impressive.

[Qiu]

@taxtechfl 

Glad to help and thank you for the accept mark. 😁