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?:

[BS_THE_ANALYST]

@imadorkous1 here's one way:

[ShankerV · Accepted solution]

Hi @imadorkous1 

One way of doing this.

Input was:

Output:

Please feel free to ask if you have more questions.

Many thanks

Shanker V

[imadorkous1]

Thank you! I also needed to pull in the main header as well into the columns. 

[imadorkous1]

Thanks! This definitely helps!!