Converting table to flat file (transpose 2 rows header)

[O_Mel]

Dear community,

Could anyone please suggest how should the workflow look like to perform a conversion from standard table to flat file structure? Please see the simplified example attached.

The problem that I have faced is that I could not find an efficient way how to transpose 2 rows header (highlighted yellow).

 

Please find attached the excel version of the example. 

Thank you in advance for your help!

[fmvizcaino · Accepted solution]

Hi @O_Mel ,

You need to separate the headers from the dataset in order to accomplish what you need. I'm attaching a suggestion here. 

Best,

Fernando Vizcaino

[DavidP · Accepted solution]

This is a bit of a hack, but in kinda works.

[O_Mel]

Thank you!