Taking Main header and location and put into its own column

imadorkous1

Hello,

I have the following sample table that I would like to convert from. Please note the main header is a merged cell, and I would like to take the main header and location into its own columns:

And I would like to have the solution look like this. How would I go about doing this in designer?:

ShankerV

Hi @imadorkous1 

One way of doing this.

Input was:

Output:

Please feel free to ask if you have more questions.

Many thanks

Shanker V

Input file.xlsx

Output 24022023.xlsx

Taking Main header and location and put into its own column.yxmd