Hi @Kamran1991 ,
I'm not entirely sure I understand what you are looking to do, but I think I'm understanding that the problem is that since the data is merged into one cell in Excel, when you read it into Alteryx, it only comes in the first cell. Then you are left with no header above Calcutta and Chennau to show they are part of India. When this type of problem happens, you need to tranpose the data and use the multi-row formula tool to fill in the blanks. Then when done, crosstab the data back.
Here is an example of how you do that. Let me know if you have any quesitons.
Maureen
