Results 1 to 5 of 5

Thread: How to copy a pivot table into a 2 dimensional table ?

  1. #1
    Join Date
    Aug 2010
    Posts
    63

    How to copy a pivot table into a 2 dimensional table ?

    Hello everyone, I am having a desktop system . I am using Windows Xp home edition of operating system . I have just installed Microsoft Office 2007 and use excel mostly. I am working in a marketing firm as an analyst, So I spend a lot of time with MS Excel so that I can do all the calculations in it, but I have heard from my friends that a Pivot table helps more in doing a tabular analysis of data and is more flexible.Can any one comment on this. Post your replies.

  2. #2
    Join Date
    Apr 2009
    Posts
    356

    Re: How to copy a pivot table into a 2 dimensional table ?

    A PivotTable report can help you see the "big picture" by summarizing and analyzing your data. You can control how Excel summarizes the data—for example, by sum, average, or count—without entering a single formula. In a PivotTable report, you can quickly:
    • Add or remove data

    Not quite enough information in your PivotTable report? Maybe you want to include data such as sales figures broken down by salesperson. In a PivotTable report, you can easily add or remove categories of data.

    • Rearrange the layout

    Not satisfied with the layout of your PivotTable report? For example, you might prefer to display the salesperson information in rows instead of in columns. The interactive nature of your PivotTable report lets you literally turn the table: You can easily move (or pivot) the rows and columns to view different summaries of the data.

    • View a subset of the data

    Want to filter (filter: To display only the rows in a list that satisfy the conditions you specify. You use the AutoFilter command to display rows that match one or more specific values, calculated values, or conditions.) the data so you can view a manageable chunk at a time? To do this, you can use a page field (page field: A field that's assigned to a page orientation in a PivotTable or PivotChart report. You can either display a summary of all items in a page field, or display one item at a time, which filters out the data for all other items.) to break the PivotTable report into separate "pages." Each page contains a subset of the data that's summarized in the PivotTable report.

  3. #3
    Join Date
    Aug 2010
    Posts
    63

    Re: How to copy a pivot table into a 2 dimensional table ?

    As you suggested I started using Pivot table and is really it has a lot of tools to do calculations and analyze the data. But there is one issue with issue with this pivot able . I cannot copy the contents of this Pivot table into a to dimensional or a flattened table. Whenever I attempt to do the same , The cell in the original table go empty. Please can anyone tell me how can I convert the Pivot table into another without making any changes in the original content ?

  4. #4
    Join Date
    Nov 2009
    Posts
    353

    Re: How to copy a pivot table into a 2 dimensional table ?

    You mentioned that when you copy the whole table and paste in the new one , I did not get when you said that the left hand portion of original table remains empty. I would suggest you to follow my instructions . Place the cursor in the pivot table select the entire table after you have chosen Pivot Table tools. click right and select the the copy option and paste it were you want. The table which is created after copying is the Pivot table as well. But if you wish to copy into a non pivot table then after selecting copy it into other once you have chosen it's Home and Paste values.But let me remind you that the data stored in this newly created non pivot table is not connected to the range but to the source table or the original Piviot table from where it was been created.

  5. #5
    Join Date
    Apr 2008
    Posts
    4,089

    Re: How to copy a pivot table into a 2 dimensional table ?

    Yes it will not copy that easily, copying a pivot table to another will leave blank spaces or cells in the newly created table .This happens normally when the source table contains some complicated data and the copied table which is newly created without any complications specially in complicated scenarios.You can fill this empty cells using the VBA coding but it is too complicated step and I would suggest to better stay away form it. Because the coding is not my cup of tea, cant say about yours.

Similar Threads

  1. What is the way to sum up number of column in Pivot Table
    By Dvimida in forum MS Office Support
    Replies: 2
    Last Post: 09-02-2012, 06:31 PM
  2. How to unpivot the pivot table in excel
    By Raju Chacha in forum MS Office Support
    Replies: 2
    Last Post: 08-01-2012, 02:13 PM
  3. Link a Table to another Table to Drop Down In Main Table
    By himeshRES in forum Windows Software
    Replies: 6
    Last Post: 11-12-2010, 01:01 PM
  4. 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, 05:48 AM
  5. How to copy one table data into another table directly?
    By ComPaCt in forum Software Development
    Replies: 3
    Last Post: 22-09-2009, 03:54 PM

Posting Permissions

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