Merge the header for multiple columns

Kamran1991

Hi community members,

Hope everyone it doing great.

I have data related to cities and their respective countries.

I want to change the orientation of data but want to merge the header of multiple columns, like this

Somebody please help me in solving this!

Anticipatory thanks!

Kamran

Example in excel.xlsx

messi007

@Kamran1991,

Please see below :

Attached the workflow,

Hope this helps!

Regards,

Merge_20220523.yxmd