I 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.