About Us

Justin Hoffmann

Thanks. I'll give that a try.

n article , Ron Coderre at
wrote on 7/12/06 10:56 AM:

Take a look at Pivot Tables....I think they'll give you the flexibility
you're looking for.

Here's how to set it up:

<Data<Pivot Table
Use: Excel
Select your data
Click the [Layout] button

ROW: Drag the Industry field here
ROW: Drag the State field under the Industry field
DATA: Drag the EmploymentData field here
If it doesn't list as Sum of EmploymentData...dbl-click it and set it to Sum
Click [OK]
Select where you want the Pivot Table...and you're done!

To refresh the Pivot Table, just right click it and select Refresh Data

Post back with any questions.

Does that help?
***********
Regards,
Ron

XL2002, WinXP

"Justin Hoffmann" wrote:

Hello,

In my work, I download a lot of statistical data from government sources.
Unfortunately, the data is usually presented in a way that is not easy to
manipulate or work with. Right now, I am working employment data for the 50
U.S. states.

The spreadsheet I currently have essentially has three really long columns.

The first column is the state name (United States, Alabama, Alaska,
Arkansas, Arizona, etc.)

Second column is the the industry (Agriculture, manufacturing, retail, etc.)

Third column is the data for employment.

Rather than having all of the data in long (6000+ rows), I want to place
each of the states in to their own column. So the final table would look
something like this:

First column: Industry
Second column: U.S. data
Third Column: Alabama data
Fourth column: Alaska data
Fifth column: Arkansas data

And so on until the last state

Is there an easy way to accomplish this rather than using cut and paste?

Thanks for your help and suggestions.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro question	Chris	Excel Worksheet Functions	12	July 7th 06 01:23 AM
creating a bar graph	Johnfli	Excel Discussion (Misc queries)	0	October 26th 05 08:16 PM
Stack multiple columns into one column... is there an easy way?	Julian	Excel Discussion (Misc queries)	2	September 16th 05 07:31 PM
Reference multiple cells in if statement	PAR	Excel Worksheet Functions	1	June 10th 05 06:28 AM
merge data from multiple columns to single column	triggerthehorse	Excel Worksheet Functions	2	January 17th 05 07:19 PM

Menu

About Us