How to convert data from vertical to horizontal

[amitshaw11237]

I want to convert data from vertical to horizontal, but I want more than first and the last value, as crosstab can return only either first or last record. But suppose I have 3 or more than how to return all the values. For example:

Input:

ID	Column_Header	Name
ABC123	Col1	Request 1
ABC123	Col2	Request 21
ABC123	Col2	Request 22
ABC123	Col3	Request 3
ABC123	Col4	Request 41
ABC123	Col4	Request 42
ABC123	Col4	Request 43
ABC123	Col5	Request 51
ABC123	Col5	Request 52
ABC123	Col6	Request 61
ABC123	Col6	Request 62
ABC123	Col6	Request 63

Output:

ID	Col1	Col2	Col3	Col4	Col5	Col6
ABC123	Request 1	Request 21	Request 3	Request 41	Request 51	Request 61
ABC123		Request 22		Request 42	Request 52	Request 62
ABC123				Request 43		Request 63

[PhilipMannering]

You need a grouped record ID which you can do with a Multi-Row Tool or Tile Tool,

[JosephSerpis · Accepted solution]

Hi @amitshaw11237 you can use a Multi-Row tool before you use a crosstab to create a rank field to use in the crosstab tool to ensure all records are spread across different lines. I have mocked up a workflow which showcases one way to approach this.

[Qiu]

@amitshaw11237 
I will go with my favorite Tile tool.

[amitshaw11237]

Thank you for the solution, it worked like a charm!