Results 1 to 4 of 4

Thread: How to merge columns of Pivot Table in single Row Heading

  1. #1
    Join Date
    Aug 2011
    Posts
    79

    How to merge columns of Pivot Table in single Row Heading

    I have a pivot table that I am trying to extract various forms of data on, about child/parent attendance at different location, the numbers are doing fine but I want to use PT to create a 'contact list'.

    I have in the master table these columns :
    1. Parent Name
    2. Phone
    3. Email


    I would like a PT where I can see:
    • Parent Name 1 Phone Email
    • Parent Name 2 Phone Email
    • Parent Name 3 Phone Email
    • Parent Name 4 Phone Email
    • Parent Name 5 Phone Email
    • Parent Name 6 Phone Email
    • Parent Name 7 Phone Email

  2. #2
    Join Date
    Apr 2010
    Posts
    71

    Re: How to merge columns of Pivot Table in single Row Heading

    You could put all three fields in the row area, and another field in the data area. For each row field, turn off the subtotals and then manually hide the worksheet column that contains the data.

  3. #3
    Join Date
    Apr 2010
    Posts
    91

    Re: How to merge columns of Pivot Table in single Row Heading

    I can provide you some workarounds for Excel Pivot Table. It is basically based on cell consolidation. Here, the first consideration is to have the same pattern on each sheet. That is, each column in the database has a unique title and this title should be the same for each table in each sheet. Define a range name for each table which is also advisable. Under the main menu option "Data", select PivotTable Wizard. Then, check the option of Multiple Consolidation Ranges. In the next window select the second option which is Custom page fields and then click Next. This is first range to consolidate it. Click the "Add" button, select 1 also to the question. Type the name of the sheet in the box at the bottom of this window and repeat the same.

  4. #4
    Join Date
    Apr 2010
    Posts
    23

    Re: How to merge columns of Pivot Table in single Row Heading

    The above method is far more confusing. Just try this. Data fields appear in the next step. Drag and drop the label on the area where you want them to be displayed. For example. Drag "Column" to the area PAGE and then drag "Page" to the column area. Now double click on the tag values. Choose a mathematical operator (Count, Sum, Average ...) and then click on "Next. Select where to place the PivotTable and click the Finish button.

Similar Threads

  1. How to sort multiple columns in Excel Pivot Table
    By Nicoloid in forum MS Office Support
    Replies: 2
    Last Post: 17-02-2012, 08:01 PM
  2. Replies: 2
    Last Post: 16-02-2012, 06:28 PM
  3. Replies: 5
    Last Post: 27-08-2011, 10:53 AM
  4. How to copy a pivot table into a 2 dimensional table ?
    By Udyami in forum Windows Software
    Replies: 4
    Last Post: 27-11-2010, 11:35 PM
  5. To convert a pivot table to a flattened table in MS Excel
    By zeemga in forum Windows Software
    Replies: 3
    Last Post: 27-11-2010, 06:48 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
  •  
Page generated in 1,711,666,998.74358 seconds with 18 queries