Adding more rows to column field names

[Mwatts23]

Hi,

I would like to seek your help regarding adding more rows in the column field names.

I was exploring the Cross Tab tool but it is not working for me in stacking 3 fields as column names.

Below is the screenshot of the sample data and the expected output. I also attached the xlsx file for reference.

 Please let me know if you have any clarifications on my query. Thank you.

Best regards,

Michael

[Mwatts23]

Hi @binuacs,

From your workflow, Is it possible for the country, region and metro not to keep on duplicating on the final output? because I have 11k+ account ids on my data and it gives me 11k+ column names as well.

Best regards,

Michael