Thread: Data concantating
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RobM RobM is offline
external usenet poster
  
Posts: 17
Default Data concantating
Any idea's as to take data that looks like this:

1st column 2nd column
10075 6L
10075 6M
10075 6O

And make it look like this:

1st column 2nd column 3rd column 4th column
10075 6L 6M 6N

Reply With QuoteReply With Quote