Merge rows with same records

[Pooja_Khanna]

I have following table as a dataset. I am looking forward to merge cells with same records for all the columns

Country	Province	City
CAN	ON	Toronto
CAN	ON	Toronto
CAN	ON	Mississauga
CAN	AB	Edmonton
CAN	AB	Calgary
CAN	NS	Halifax
CAN	NS	Halifax
	NS	Lunenburg
US	CA	SF
US	CA	SF
US	TX	Austin
US	TX	Austin
US	TX	Dallas
US	TX	Dallas

Desired output is: I am not able to paste the desired output. But I am looking to merge cells in a way that every country, province and city appears only once. 

Sample input and output is attached with this.

[Luke_C]

Hi @Pooja_Khanna 

Alteryx isn't going to be able to merge cells like this. You could use multi-row formulas to mimic this but I'm not sure if that's valuable for you:

[Pooja_Khanna]

I tried multi-row formula but that's not helping as my purpose is to avoid users to sort data and mess-up with rows. That's why merging is needed.

[Yoshiro_Fujimori]

Alteryx is powerful when used to cleanse data from a dirty data (like a table with merged cells) to a clean data (like a table in normalized form),

but not so powerful to make a clean data back to a dirty data.

For your use case, maybe you would be better to use Data Visualization tools, like Tableau, Power BI etc.

(Though this is not Tableau community, just for example)

with Tableau, you can make this table with a few clicks, keeping the original data clean.

[jirikrecek]

You don't need Alteryx for this at all! What you have shown in your second screenshot is a very simple Excel Pivot table in Tabular formatting. That is literally all you need. No Alteryx required.