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