Pivot Table

[duttaabhishek7]

Hello Friends,

I am providing below the data and the desired output which I want. I have used Summarize tool to get the Pivot. However I am not able to get the output in below format in Alteryx. I am a very new alteryx user. Please suggest me how to get data in the below output format.

Input Data (This is a sample data, the actual data set is much bigger)

Country	Company Code	Company Name
Argentina	AR01	ELANCO S.R.L.
Argentina	ARG1	Country Template AR
Austria	AT01	Elanco Austria GmbH
Australia	AU01	Elanco Australasia PtyLtd
Australia	AU90	Elanco Australia Holding

Output Data after using pivot table in Excel (I want to apply configuration  in alteryx which will give me the Pivot table in below format)

Country	Company Code	Company Name
Argentina	AR01	ELANCO S.R.L.
Australia	AU01	Elanco Australasia PtyLtd
	AU90	Elanco Australia Holding
Austria	AT01	Elanco Austria GmbH

[jdminton]

@duttaabhishek7 can you rephrase your request? What is your end goal? Creating an output that would match is not difficult, but if you are trying to summarize data to get the output, your input data does not align with a summarize. Also, the pivot table in Excel has an option to leave out repeating "Country" as shown in your output, but in working with data, you would not want to remove that while it remains in Alteryx as each data line needs that information in order to remember it. It's similar to the Excel table you're building your pivot table from.

[usmanbashir]

@duttaabhishek7 attached workflow empties out repeating countries (using multi-row formula tool). I do think you also wanted two lines for Argentina, instead of 1 in your output data example. Hope this helps. 

[Raj]

@duttaabhishek7 

this can be achieved by combination if 2 tools first a unique tool to get unique and non-repetitive "country code."
{kindly arrange the countries prior to this as it will take only first record as unique and rest as duplicate}
 then a multi row formula to have blank in place of repetitive country.

hope this helps.