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 

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 : )

format data.yxmd