View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Abhay Abhay is offline
external usenet poster
 
Posts: 14
Default multiple rows to single row

It can be upto 5000 to 10000 and any text e.g. PT-1001 etc.

"JMay" wrote:

How high do your letters go (c,m,z,ab)?

"Abhay" wrote:

I have Data which is like
a 1
a 2
a 3
b 1
b 2

This I would like to regroup this as following
a 1 2 3
b 1 2 and so on.
Issue is -
Number of times a .... appears is not fixed.
Number of unique รค,b in column is not fixed
All data is text only, as an example I used numbers here.
Help appreciated. Thanks.