macro help = extract content of specific columns accross a row

have a spreadsheet which consists of about 5125 rows and 2840
columns. I am using Excel 2007 in order to get access to the extra
columns. Now I need help creating a macro to automate a very tedius and

manual task. The first column in the spreadsheet is empty.

What I Need
===========
For every row I would like to extract the contents of certain columns
accross the row and copy to the first column of the row.


into the first column i would like to copy the contents of the
following columns accross the row. 6C = sixth column, 9C = 9th column
etc...


6C + " " + 7C + " " + 9C + " " + 35C + " " + 37C +
<carriage return>
+ 12C + " " + 14C + " " + 18C + " " + 70C + " " + 74C +
<carriage return>
etc...


I need the macro to be smart enough to continue adding carriage returns

and multiplies of the original columns, until it reaches the end of the

row.


I need to do this for every row.


Any advice please or code would be greatly appreciated.

anyone? ..