| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining data from two columns into one - appending new value
Does this help?
http://www.freefilehosting.net/download/3ej13 Regards, Ryan--- -- RyGuy "Herbert Seidenberg" wrote: In step 1 of the Pivot Table Wizard make sure you selected Multiple Consolidation Ranges. In step 2b, the three sheet ranges are listed as defined names. Insert Name Define Dat1 =Sheet1!$A$3:$B$6 Notice that the range includes a column to the right of the numbers and a row on top. I recommend that you start out using my file as a template, patching your data into it. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Spreadsheet combining data from 3 columns to 1 column | Excel Discussion (Misc queries) | |||
| Combining 1 column into many columns | Excel Discussion (Misc queries) | |||
| combining multiple columns into one column - enhancements | Excel Worksheet Functions | |||
| Combining mutiple columns into one column | Excel Worksheet Functions | |||
| Appending Values in the Legend | Charts and Charting in Excel | |||
Threaded Mode
