Convert col to rows

[videet]

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

[KarolinaRoza · Accepted 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

[atcodedog05 · Accepted solution]

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 🙂

[videet]

@atcodedog05 @KarolinaRoza 

Thanks a lot guys!!