Pivoting using Cross Tab

[LStevenson]

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. 

 

 

[rfoster7]

You don't want the Cross Tab tool, you want the Transpose Tool. That's the Tool for turning columns into rows. 

 

[LStevenson]

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? 

[KaneG · Accepted solution]

You'll want to firstly transpose the 3 columns and then Crosstab that. The Crosstab will be Group: [Name], Header: [State], Data: [Value]

[rfoster7 · Accepted solution]

That's correct. Here's a sample pic

 

[LStevenson]

That is exactly what I needed! Thank you so much. Now I understand the pivot concept!