Move Data From Vertical to Horizontal

  • Thread starter Thread starter fattire
  • Start date Start date
F

fattire

How do I get my speadsheet to move from vertical meaning:
Name Type Hours
Bob Regular 80.00
Bob OT 10.00

To look like this:

Name Regular OT
Bob 80.00 10.00

If anyone can help PLEASE comment.
 
Hi Debra,
Yes I think you may be right.
My ironism has seemed to backfire-upon me!
mpb

Hi Mathew,

I think you meant ????a

Or, in my case, ???? eh?

Debra
Hi ****a
Sorry Debra/Myrna could not resist!
Mathew
You can create a pivot table to summarize the data. There are some
instructions and links here:

http://www.geocities.com/jonpeltier/Excel/Pivots/pivottables.htm

For your example, add Name to the Rows area, Type to the Column area,
and Hours to the Data area.
Click to expand...
 
Back
Top