Transform and transpose row to column with corresponding values

[mrnice]

Hi all,

I have the following table which I would like to use the data contained in the Name column and use it as a new column with the correspondent values. I tried to used transpose without success so any help would be appreciated.

Name	Values
abc	AB1
cba	AB3
abc	SG1
cba	AD12
abc	AD3
cba	AB1
abc	AD3

Final output should look like:

abc	cba
AB1	AB3
SG1	AD12
AD3	AB1
AD3

[charlie_archer · Accepted solution]

Hi there,

I worked around this using a combination of a Multi-row formula and Crosstab tool (see the attached workflow)

Step 1 was to give each of the [Values] a rowID restarting for each [Name] using the Multirow formula. Once i had this i could use this new RowID as the key field with which to crosstab my data back out.

Hope this method works for your data.

Charlie

[mrnice]

Thanks Charlie.

Exactly what I was trying to achieve.