Arranging Data

[KmbrlyPC]

I have a set of data in which I am needing it to be displayed horizontally instead of vertically so I end up with just 1 name per line. For example, currently John is listed 3 times with each subject and grade, but I want this information displayed all on 1 row.

[atcodedog05]

Hi @KmbrlyPC 

Can you provide the example as an excel file so that we can work on it.

[KmbrlyPC]

Here you go, thanks.

[atcodedog05 · Accepted solution]

Hi @KmbrlyPC 

Here is how you can do it.

Workflow:

1. Using muti-row formula tool I am creating sub id. This will be used for identifying as subject(1), subject(2) etc

2. Using Transpose tool to convert subject and grade to rows.

3. Using formula tool to create column order. I,e while using crosstab columns are always arranged in ascending order. And creating new name as subject(1), subject(2) etc

4. Using crosstab to converting into table.

5. Using dynamic rename to rename the column name.

Hope this helps : )

[KmbrlyPC]

It worked beautifully, thank you!