| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
"Unwrap" Excel list into table, to facilitate pivot
I have long lists compiled by users in rows, which look like this:
UserName1 Costcentre1, Costcentre2 UserName2 Costcentre3, Costcentre4, Costcentre5 UserName3 Costcentre6 UserName4 Costcentre7, Costcentre8, Costcentre9, Costcentre10 and so on. I need to reconstruct this data so that I have this in tabular form like so: Costcentre1 Username1 Costcentre2 Username1 Costcentre3 Username2 Costcentre4 Username2 etc., so that I can perform further pivot analysis. What's the good way of doing this? I have more than a thousand rows. -- Sriram |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"Unwrap" Excel list into table, to facilitate pivot
In your input data:
UserName1 Costcentre1, Costcentre2 are Costcentre1 and Costcentre2 in separate cells (B1 and C1) or are they comma-spearated values within a single cell? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"Unwrap" Excel list into table, to facilitate pivot
These are comma-separated values in a single cell (B1)
-- Sriram "James Ravenswood" wrote in message ... In your input data: UserName1 Costcentre1, Costcentre2 are Costcentre1 and Costcentre2 in separate cells (B1 and C1) or are they comma-spearated values within a single cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
| Pivot Table Report Filter - "OR" instead of "AND" Multiple Filters | Excel Discussion (Misc queries) | |||
| "Show Field List" in Pivot Table Toolbar doesn't work | Excel Discussion (Misc queries) | |||
| Pivot table "Group and Show Details" vs. "SubTotals" | Excel Programming | |||
| Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming | |||
Linear Mode
