Transform and transpose row to column with corresponding values

Question

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.

NameValuesabcAB1cbaAB3abcSG1cbaAD12abcAD3cbaAB1abcAD3

Final output should look like:

abccbaAB1AB3SG1AD12AD3AB1AD3

charlie_archer · Accepted Answer

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