"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

"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?

"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?