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 |
Solved! Go to 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
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 |
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
Great thanks Phil!