Tableau Pivot Rows into Columns

Question

I have a table structure like this:

Department   Employee  Class Peroid   Qty1 Qty2 Qty3
----------------------------------------------------
Dept1        John        1     1st    1    2    3
Dept1        John        1     2nd    11   22   33
Dept1        Mary        1     1st    2    3    4
Dept1        Mary        1     2nd    22   33   44
Dept2        Joe         1     1st    3    4    5
Dept2        Joe         1     2nd    33   44   55
Dept2        Paul        1     1st    4    5    6
Dept2        Paul        1     2nd    44   55   66

In a view I'd like to display the format as such:

                           Class  /  Period
                                  1
Department    Employee      1st       2nd
----------------------------------------------
Dept1         John         1  2  3   11 22 33
Dept1         Mary         2  3  4   22 33 44
Dept2         Joe          3  4  5   33 44 55
Dept2         Paul         4  5  6   44 55 66

I can't seem to find a way to do this. I have Class, Period as Columns and Department, Employee as Rows then drag Qty1, Qty2, Qty3 to the Text Mark but the format becomes:

                           Class  /  Period
                                  1
Department    Employee      1st       2nd
----------------------------------------------
Dept1         John          1         11
                            2         22
                            3         33   
Dept1         Mary          2         22 
                            3         33
                            4         44 
Dept2         Joe           3         33 
                            4         44
                            5         55  
Dept2         Paul          4         44
                            5         55
                            6         66

How do I turn those rows under each employee to sub-columns under Period?

Answer 1

A lot of times when you see a repeating column in a database table, Qty1, Qty2, Qty3, it is a sign that you really want multiple rows each with a single Qty (and repeating the other information) -- At least when you are building reports. That way you can have rows with any number of instances of Qty, and you can also easily aggregate all the Qty together when needed.

There are situations where you may want to stick with a repeating field design. But if you do want to reshape the data, you can do that in Tableau's data connection window by selecting the columns you want to pull out into a single field and selecting the pivot command.

Answer 2

I think this is what you're trying to achieve.