Transpose

[jlfromm]

 In Alteryx I have this Data I want it to look like this something like the example below 

                                                           Avera - Aberdeen                  Avera Milbank 

Total Unit / Hours Nursing Service                1595                                163.75

Total Unit/Hours Homemaker                        15837.5                            453

[trsali · Accepted solution]

Hi @jlfromm You have to use a transpose then a crosstab to achieve your outcome. 

[binuacs · Accepted solution]

@jlfromm One way of doing this