Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how convert Exsel crosstab to table
- Thread starter alla1921
- Start date
What do you mean by *crosstab* and *table view*?
To me...they are the same.
Perhaps you have some type of subtotal on the sheet? Try these ONLY if they are *available* (not grayed):
Data-Subtotals-Remove all
Data-Group and Outline-Clear Outline
Window-Unsplit
Anne Troy
To me...they are the same.
Perhaps you have some type of subtotal on the sheet? Try these ONLY if they are *available* (not grayed):
Data-Subtotals-Remove all
Data-Group and Outline-Clear Outline
Window-Unsplit
Anne Troy
SkipVought
Programmer
alla1921,
Use the PivotTable Wizard on the crosstab.
In Step 1, select Multiple Consolidation Ranges
In Step 2, select I will create page fields
With cursor in Step 2b Range box, select the table range and Add
In Step 3, Hit the Layout and drag the COLUMN & ROW fields OFF the COLUMN & ROW areas
Finish on a new sheet
Double-click the unique value and VOLA!
Skip,
Skip@TheOfficeExperts.com
Use the PivotTable Wizard on the crosstab.
In Step 1, select Multiple Consolidation Ranges
In Step 2, select I will create page fields
With cursor in Step 2b Range box, select the table range and Add
In Step 3, Hit the Layout and drag the COLUMN & ROW fields OFF the COLUMN & ROW areas
Finish on a new sheet
Double-click the unique value and VOLA!
Skip,
Skip@TheOfficeExperts.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question