I have input table as below i want it to be converted in output table format.
I tried to use cross
Input table
Name | Value |
ID | 1 |
Phone | 123 |
Add | abc |
ID | 2 |
Phone | 456 |
Add | xyz |
ID | 3 |
Phone | 789 |
Add | xyz |
Output
ID | Phone | Add |
1 | 123 | abc |
2 | 456 | xyz |
3 | 789 | xyz |
Solved! Go to Solution.
Hi @videet ,
This was tricky 🙂 but hopefully I hope my simple workflow provides you what you need.
To use Cross Tab tool, firstly you need to assign unique value for each group of columns (1 -> ID: 1, Add: abc, Phone: 123, 2-> ID: 2 etc.)
Regards,
Karolina
Hi @videet
Here is how you can do it.
Workflow:
1. Using multi-row formula tool I am creating groups. A new group starts on each occurrence of ID in Name. Each group is identified by key column row
2. Crosstab using row as key, name as name and value as value.
Hope this helps 🙂
Thanks a lot guys!!