Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Building a pivot with a massive data set
Hello all
First time poster and I am hoping for some kind help today. I have a large set of data that I would like to organize quickly. Currently, the data is set in two columns. Column A contains parent names (almost 5800) and column B contains child information. The child information can contain multiple values (in some cases hundreds of values) which are separated by a comma. My goal is to be able to select a particular child value and return all parents which have that child. I assume that this can be accomplished with a pivot table yet I am unclear on how to arrange the data in order to build an effective pivot. Can anyone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Issue building pivot tables with certain names | Excel Programming | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Seperate massive data within 1 cell into individual columns | Excel Programming | |||
Building Pivot table from Access data | Excel Discussion (Misc queries) | |||
Pivot Cache - Massive Spreadsheet | Excel Discussion (Misc queries) |