View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
SriramNA SriramNA is offline
external usenet poster
 
Posts: 4
Default "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?