Convert column headers and sub-headers into row format of data

[db89]

Hi,

I have a complex table which has headers and sub-headers which has to be converted into logical row values as per attachment 'Test Template1'  in the form of aggregated 'OUTPUT' file (attached).

I have used 'Multi-Row Formula' tool to fetch data in Parts 3 only, but unable to convert as per the aggregated 'OUTPUT' format. 

No. of input files will be ranging from 10 data sets in same structure but with dynamic set of headers and sub headers. 

Any help on this will be highly appreciated.

[Qiu]

@db89 
Parsing the non-structured data is really a case-by-case work and a slight change on the structure can lead to workflow fails.

So only want to show my idea on how to proceed based on the provided data.

[db89]

@Qiu Hi Qiu, 

Appreciate your response! 

I have updated the input file in the message. 

The initial version does not seem to be working, probably a mistake from my end with the template I have shared.

Would you be able to help on the current version though?

[Qiu · Accepted solution]

@db89 
A quick fixed one. 😀