How to collate onto one line VBA? Lookup?

[DaveR]

We have a webform that generates an excel file. Sadly the webform appears to be particularly stupid and is generating a new line of every piece of new data. What I want to do is have the data on one line.

For example;

AF174665	2011-07-27 13:51:19.763000+0100	Fostering					
AF174665	2011-07-27 13:51:19.763000+0100		ISP CENTRE				
AF174665	2011-07-27 13:51:19.763000+0100			Wendy Fields			
AF174665	2011-07-27 13:51:19.763000+0100				Referrals Manager		
AF174665	2011-07-27 13:51:19.763000+0100					April - June	
AF174665	2011-07-27 13:51:19.763000+0100						275

The first column is the unique ID code (although to be fair the second column has the same data).

Which is the best way to do this? There are 23,000 odd lines of data so I suspect VBA would be quickest?

 

[DaveR]

After an hour, the routine completed. However, it doesn't appear to have done it correctly.

Using the second macro (meant to be faster - took just under an hour on the work computer!) it seems to have done what is requested but the data in the rows D-KM don't appear to have been copied at all (i.e. there is no data in these columns?

Using the first macro, this is also bereft of any data in the other columns?

Not sure why the information isn't being retained?