Unstacking Data with multiple headers

[aileenr]

Hello,

I am trying to turn the attached data (screenshot) into readable database format.

So make all week headers be on the first row, so weeks 16 to 52 should be to the right of week 15 on the top row. Any ideas?

[Emil_Kos]

Hi @aileenr,

Can you send the excel data file? 

[AngelosPachis]

Hi @aileenr ,

I would start by using a multi-row formula tool to number the different sections. The logic behind my expression would be "If the value of the Relation column is "Relation", then Row-1 of the column I'm creating +1 Else Row-1 of the column I'm creating. That will create a numeric identifier from 1-4.

That will enable you to split your different sections and the join them back together using a join tool configured to join on record position.

Hope this is somewhat helpful,

Cheers,

Angelos

[aileenr]

Attached is excel file

[aileenr]

It's been added!

[DawnDuong · Accepted solution]

hi @aileenr 

I think something like this is more useful for further downstream analysis. Hope this helps you