Transpose different tables of a file

Hi All,

I get a file in a specific format. Where First table "Customer master data" contains master data and another table "Directors/Signatory Details" contains their director names (refer to sample 1 and sample 2). There might be another table but I want to ignore that. I want to convert these files in a format as specified under output.xlsx. Please help me out.

sample 1.xlsx

sample 2.xlsx

Output file.xlsx

Transformation

Accepted answers

Qiu

@caneerajdwivedi

This is the one I prepared.

0408-caneerajdwivedi-r1.yxzp

All comments

Qiu

@caneerajdwivedi
It is not that pretty.

0408-caneerajdwivedi.yxzp

caneerajdwivedi

Thank you so much. It works pretty well. Just one thing.. i've thousands of these files. Can we make input directory-based, like alteryx will read and convert all files in a specific directory?

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703