Headers in multiple rows and clean up on date fields

Hello

I am having difficulty establishing the correct structure on an excel file as the headers are in multiple rows and more than one headers are in one column etc. I will show the current input:

I would like to have data highlighted in yellow turned into columns and output like so:

Basically adding Customer name and invoice currency as headers at beginning of table and concatenate the word quantity to each month.

Capture. PNG.PNG

I appreciate any guidance or even a sample file of something similar to help with a solution. I have attached the input data as tabs Customer x, y etc and desired format is tab 'Consolidated Customer Data'.

Thank you 🙂

Learning Sample.xlsx

Datasets

Parse

Transformation

Tableau

Accepted answers

benakesh

Hi @CH217 ,

Attached wf reads 3 sheets and appends customer name and currency to all records .

The union combines data from 3 sheets . The status is blank in 3 input sheets and output .

Learning Sample.yxmd

All comments

benakesh

Hi @CH217 ,

Can you share sample data ? It is easier to provide working solution than explaining how to .

CH217

Hi @benakesh

Thank you for your response 🙂 I have attached a the sample input file. Tabs with Customer X, Customer y etc are the inputs and tab 'Consolidated Customer Data' is the desired structure. Thank you for taking the time to investigate this.

benakesh

Hi @CH217 ,

Attached wf reads 3 sheets and appends customer name and currency to all records .

The union combines data from 3 sheets . The status is blank in 3 input sheets and output .

Learning Sample.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703