I am a new user and am trying to do my first Cross Tab pivot. My data has 4 columns. The first is the the states where we have plants. The 2nd through 3 tabs are plant data. I can't figure out how to turn the 3 columns of data into 3 rows of data (plus the state header). I can only pick up a single row of data. I would like to have all three rows of data by state.
I'm attaching two pics. The first is my data before I Cross Tab and the second is my cross tab results.
Solved! Go to Solution.
You don't want the Cross Tab tool, you want the Transpose Tool. That's the Tool for turning columns into rows.
I wanted the data to be shown horizontally with the states as the header and the 3 rows of data in columns below the appropriate state. Is that possible?
You'll want to firstly transpose the 3 columns and then Crosstab that. The Crosstab will be Group: [Name], Header: [State], Data: [Value]
That's correct. Here's a sample pic
That is exactly what I needed! Thank you so much. Now I understand the pivot concept!