How to organize a single column of stacked arrays into structured table

[beckdog]

I could sure use some advice on how to convert a single column of stacked arrays into a table in Excel. My data is in a single column where the first 34 rows contain table headers, and the remaining rows represent table data related to those headers. Example:

tableheader1
tableheader2
tableheader3
tabledata-a1
tabledata-a2
tabledata-a3
tabledata-b1
tabledata-b2
tabledata-b3
tabledata-c1
tabledata-c2
tabledata-c3

What is the best method to organize this column of data into a structured table? Thanks for any advice! Example of desired output:

tableheader1 tableheader2 tableheader3
tabledata-a1 tabledata-a2 tabledata-a3
tabledata-b1 tabledata-b2 tabledata-b3
tabledata-c1 tabledata-c2 tabledata-c3

[Glenn Kennedy]

One way:

=IFERROR(INDEX($A$1:$A$12,1+3*(ROWS($1:1)-1)+MOD((COLUMNS($A:A)-1),3)),"")

If you have more than 3 columns, change the 3s to whatever the number of columns is. Copy across 3 columns and down as far as needed.