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
|