Hello guys, I'm having trouble configuring a transpose-crosstab combo, for the following data :
To be clear, there is one "key column" (State) and 4 value columns. I would like to reorganise this into 8 value columns (Pause_Quantity, Pause_Total duration, ..., Active_Quantity, .. etc)
I've managed to get to this point :
But cannot seem to configure a cross-tab correctly afterwards to end up with 8 columns properly sorted.
I have shared a "dummy" excel sheet with the data like in the first picture, any help to try and make it into 8 columns would be great !
Thanks in advance,
LJ
