hi.. excel s driving me nuts ..
I wanna know how do it get values from a row to a column .. but the condition is that the each cell in a row are 4 cells apart while all cells in the column lie one after the other...

for example:

i want the values of A1, F1, K1, P1, U1, Z1

to



columns A10,A11,A12,A13....

Anyone one know this, kindly help me.. Thank you