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

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.

OUTPUT.xlsx

Test Template1.xlsx

Datasets

Transformation

Dynamic Processing

Optimization

Accepted answers

Qiu

@db89
A quick fixed one. 😀

1107-db89-r1.yxzp

All comments

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.

1107-db89.yxmd

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

@db89
A quick fixed one. 😀

1107-db89-r1.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703