| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reconstructing a table
I can pull a table out of a repository that looks like this --
Bill Mike Sarah Jill Tom Project 1 0 10 0 0 0 Project 2 40 0 0 12 0 Project 3 15 0 0 0 0 Project 4 0 0 5 0 15 I need to create some formulas to switch the table to look like -- Project 1 Mike 10 Project 2 Bill 40 Project 2 Jill 12 Project 3 Bill 15 Project 4 Sarah 5 Project 4 Tom 15 Basically taking the x-axis (people) and moving it over to be a nested under projects. I can't figure out how to get there if someone could please help. Ted |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
| entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
| Insert rows in linked table that are added to secondary table | Excel Discussion (Misc queries) | |||
| Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) | |||
| PIVOT TABLE - Summary Table into a Databasae Table. | Excel Worksheet Functions | |||
Threaded Mode
