| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Prep for pivot table
Hello. I'm trying to get about 9000 lines of data into a pivot table, but unable to do so as I'm not sure of the function to use. The layout of the data is as follows:
ID # (Column A) Column B Column C Column D ID 12222 1/1/2010 Test type 1 $15.00 Blank Blank Test type 2 $16.00 Blank Blank Test type 3 $17.00 ID 12223 1/14/2010 Test type 1 $15.00 Blank Blank Test type 4 $21.00 Blank Blank Test Type 2 $16.00 Blank Blank Test type 3 $17.00 ID 12224..... So basically I would like to fill in the blanks with the appropriate ID # and dates from above so I can run a pivot table of all 9000 lines. Currently I cannot do that because of the blank lines. The # of blank lines differs between ID #s because there are different # of tests for each ID#. Any help would be greatly appreciated! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
| Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
| Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
| I need a customer registration form template for a small tax prep. | New Users to Excel | |||
Linear Mode
