Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Pivot Table Ungrouped Data

Posted on 2009-12-28
Medium Priority
Last Modified: 2012-05-08
Hi all. I am tyring to make a pivot table in office 07 show each value of each column in each row in stead of grouping. Any clue how I can do this?

here is what i have
1      BK      08      1401010638      X
            10      14010100110      S
                  14010100310      S
                  14010102110      S
                  14010102310      S
                  14010103110      S

this is what i want
1      BK      08      1401010638      X
1      BK      10      14010100110      S
1      BK   10      14010100310      S
1      BK      10      14010102110      S
1      BK      10      14010102310      S
1      BK      10      14010103110      S

I have looked in options, but can't find. Thanks!
Question by:nywi6100

Expert Comment

ID: 26135010
You need to add a unique ID to the data (just number each line 1-999... or something) and then add that ID field to the pivot table.
Which will essentially negate the purpose of the pivot table, which sums and such on the fly, because it seems like you don't want the summaries.

Once you add the field, you can just hide that ID column, since it's only purpose is to break out your data back into details.
LVL 85

Accepted Solution

Rory Archibald earned 1000 total points
ID: 26136872
There is nothing built-in to do that (though it has been added to Excel 2010). You could always copy and paste Special-Values the table and then fill in the blanks but your pivot table would not be live.

Author Closing Comment

ID: 31670470
Thanks, stinks, but thanks.

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
MS Outlook undoubtedly is the most widely used email client.Its user-friendliness, cost effectiveness, and availability with Microsoft Office Suite make it the most popular email application.  Its compatibility with Microsoft applications like Exch…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question