Split Columns to Multiple Rows

[fjlorenzo]

I have the below Raw data and I want it to look like the Output. Thank you for your help.

RAW DATA
Name	Access 1	Access 2	Access 3
Robert	A	B	C
Mike		B
Susan	A		C

OUTPUT
Name	Access
Robert	A
Robert	B
Robert	C
Mike	B
Susan	A
Susan	C

[Maskell_Rascal · Accepted solution]

Hi @fjlorenzo 

This should work for you. 

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil

[fjlorenzo]

Thank you for your quick response. I have an additional question. I need to add additional column (App Name). Can you show me how can I modify your suggested workflow to add this additional column?

RAW DATA
Name	Access 1	Access 2	Access 3	App Name
Robert	A	B	C	X
Mike		B		X
Susan	A		C	X

OUTPUT
Name	Access	App Name
Robert	A	X
Robert	B	X
Robert	C	X
Mike	B	X
Susan	A	X
Susan	C	X

[Maskell_Rascal · Accepted solution]

Sure thing! In the Transpose tool, select the field App Name as well as the already selected Name field under Key Columns. 

When using the Transpose tool, Key Columns work basically as a group by, and the Data Columns will be everything that will flip.

Thanks!

Phil

[fjlorenzo · Accepted solution]

Great thanks Phil!