Data Row Format

[SH_94]

Dear community,

I would like to ask how can we adjust the data header so that it will be as result below:

Thank for the help.

[mbarone]

What steps have you tried so far?  Meaning what tools and configurations and have you tried?

[DataNath · Accepted solution]

Here's how I'd go about it @SH_94 - the row containing the useless stacked headers is filtered out by checking that [A] doesn't = 'RM'. After this, we can then take header names from the first row of data with the Dynamic Rename tool. However, because [A], [B] and [C] are already correct, we can leave these unticked, which will result in the following:

The Data Cleanse tool likely won't be necessary when applied to your actual data, but here I just used it to remove the many null rows that came from importing your Excel file:

Any questions or if this doesn't answer your query, please let us know!

[grazitti_sapna]

@SH_94 , Here is my solution to this. Data cleansing tools will do the trick. Thanks!!

[stefaniadurdan]

Hello!

This is my proposal for you. Let me know in case of any questions.