View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] brian@justsuspension.com is offline
external usenet poster
 
Posts: 9
Default Transpose random length series of cells

Yes, each grouping is together 1.2101R, 10.1101G, etc. in column A,
and the year is in column B in sequential order. Ultimately, what I
need is for the results to be in one cell with some formatting. For
example, results for 1.2101R in C1 (shown in quotes): "1992 , 1993 ,
1994 , 1995" with the spacing and commas.