Let me make sure we understand the question.

You have 100 columns in your current worksheet.
How many rows are there in the worksheet?
Does

I1- A2
J1 -B2
K1-C2
L1 -D2
M1-E2
N1-:F2
O1-G2
p1-H2

etc?

"Jane Wee" <Jane wrote in message
...
I have 100+ spreadsheets which i have to edit into a certain format. The
spreadsheets currently have 100 columns (from 1-100). From there i have to
reduce the number of columns set to 8 columns.

E.g:
1 2 3 4 5 6 7 8
0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 (from column 9 onwards,
it
goes to the
0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 next rows' column 1)
0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

How do i do that without altering the order of the value of the cell?