Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table, Consolidating Columns
Hi,
I have some Pivot tables which get their data from an external database, the table brings back 4 columns 2 fat results and 2 Solid results No.Fat-Average Fat-Average-Retest T.S.-Average T.S.-Average-Retest 1 5.125 22.665 2 5.02 22.555 3 5.05 23.37 4 5.175 22.7 What I want to do is only have one column for each result (one for fat, one for solids) I can do this by creating a seperate column and having an If statement with the final result in it, but I wondered if there was a better way of consolidating the two columns into one? Especially as for some of the tables there can be up to 8 columns with only one having a result in it. Is there a way of doing this in the SQL statement or am I stuck with huge if statements that change as my columns change? Any help would be much appreciated Melanie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table, Consolidating Columns
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Consolidating multiple ranges | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Pivot Table - consolidating | Excel Discussion (Misc queries) | |||
Pivot Table - consolidating ranges (again) | Excel Discussion (Misc queries) |