+ Reply to Thread
Results 1 to 2 of 2

Pivot table issue-Not looking the way it should

  1. #1
    Registered User
    Join Date
    10-08-2008
    Location
    Hallandale
    Posts
    44

    Pivot table issue-Not looking the way it should

    I’m doing a simple pivot table and I’m having a problem with layout:
    I know I can move it once I'm done but I need it to come out as the right away as the last example.
    What am I doing wrong ?
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-19-2004
    Posts
    57
    nothing wrong with what you are doing...
    Excel always seems to put Data in the rows when u create a Pivot Table.
    you have to click and drag it over to the columns.

    or if you can't figure out with click and drag...
    this is the alternative method:
    Select Cell B3 ("Data"), right-click, click on Order > Move to Column

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot Table - Few complicated queries
    By acsishere in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-04-2008, 05:08 PM
  2. Critical PIVOT TABLE issue
    By ONB in forum Excel General
    Replies: 0
    Last Post: 03-27-2008, 09:41 AM
  3. Pivot table issue
    By moyemrick in forum Excel General
    Replies: 1
    Last Post: 08-23-2007, 04:18 PM
  4. Can noone help with this pivot table issue?
    By 50pingviner in forum Excel General
    Replies: 1
    Last Post: 09-26-2006, 07:25 AM
  5. Pivot table issue
    By 50pingviner in forum Excel General
    Replies: 0
    Last Post: 09-22-2006, 09:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1