Removing duplicate rows and Transposing into colummns

[laurenali]

Hi There! 

Below is a simplified version of my dataset that I am trying to transponse/simplify into a table:

Record	F1	F2
1	Unit Number	Entity A
2	Preparer	John Doe
3	Data Submitted	3/1/8/2022
4	Unit Number	Entity B
5	Preparer	Bob Smith
6	Data Submitted	4/22/2022

I would like my data to look like this:

Record	Unit Number	Preparer	Data Submitted
1	Entity A	John Doe	3/18/2022
2	Entity b	Bob Smith	4/22/2022

I think this is a simple solution but I am new to Alteryx and struggling with which tool to use here. Thanks!

[IraWatt · Accepted solution]

Hey @laurenali,

Think this is what you want:

Essentially you need to determine which fields belongs to each entity to do that I used a multi row. Then I grouped by that in the cross tab. Please ask if you have any questions.

HTH,

Ira

[IraWatt]

To remove duplicate rows you can use a summarize tool and group by all the columns.

[laurenali]

Thanks so much! That worked :)

[IraWatt · Accepted solution]

Great to hear @laurenali ! make sure to give a green solution tick if it work for you :D