Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jul 2008
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formating sheets (Excel)

    I have attached a sheet to view. I want the dates to run top to bottom and the parameters to run left to right. Is there an easy way to do this (pivot tables?). I have a bunch of sheets I have to do.

    Thanks
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Formating sheets (Excel)

    Select the range of cells,
    Edit - copy
    Go to a new sheet
    Edit - paste special - transpose

    Steve

  3. #3
    New Lounger
    Join Date
    Jul 2008
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formating sheets (Excel)

    I feel so stupid, thanks Steve this makes my life easier

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Formating sheets (Excel)

    No need to feel stupid. It is always obvious when you know the answer <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •