+ Reply to Thread
Results 1 to 2 of 2

Convert Pivot Table data to "regular" format

  1. #1
    Registered User
    Join Date
    06-04-2008
    Location
    Marietta, GA
    Posts
    18

    Convert Pivot Table data to "regular" format

    Hi -
    Is it possible to easily convert pivot table data into a "regular" format? Someone has sent me a pivot table, but for what I need to do, I really need just a spreadsheet with the data so I can sort and filter it for my needs and write some formulas to call on the data.

    I was given something like in the first screen shot here:
    pivot_1.jpg

    And I want to convert it easily to a "regular" view like this:
    pivot_2.jpg

    For the sample above, I had to copy and paste things to make it work, but there must be a simpler way. I did a Google search and a forum search, and I keep getting directed to this article:
    http://j-walk.com/ss/excel/usertips/tip068.htm Unfortunately, I followed the steps but it didn't help.

    I figure there must be a way to do this, but I am not wording my searches correctly to find the steps. Thanks for whatever help you can provide.
    Bronson Beisel
    Marietta, GA

  2. #2
    Forum Contributor Charlie_Howell's Avatar
    Join Date
    09-27-2010
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2007
    Posts
    218

    Re: Convert Pivot Table data to "regular" format

    try this copy and paste
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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