LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract info based on Name khers Excel Discussion (Misc queries) 4 July 25th 11 04:24 PM
Extract info from one sheet to another Kim Excel Worksheet Functions 2 March 15th 08 01:30 PM
Extract some info from a string mathew Excel Discussion (Misc queries) 2 October 11th 06 10:02 PM
Would it be possible to extract info from this site? IntricateFool Excel Discussion (Misc queries) 3 September 14th 06 05:55 PM
Please help: Extract some info. from a cell Bobsus5 Excel Worksheet Functions 1 March 7th 06 02:06 AM


All times are GMT +1. The time now is 04:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"