View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KH KH is offline
external usenet poster
 
Posts: 2
Default Using formula to extract info

I have a few columns of info which I want to extract (more than a 1000 rows).
111 Data1
112 Data2
112 Data3
113 Data4
113 Data5
114 Data6
114 Data7
114 Data8
How can I extract such that for the same value in the first column, the data
in column 2 is copy to the same row as the first value.
e.g
111 Data1
112 Data2 Data3
113 Data4 Data5
114 Data6 Data7 Data8


--
KH