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

in A10, put this formula: =INDIRECT("A"&COLUMN($A$1))
Then, in A11: =INDIRECT("R1C"&(1+COUNT($A$10:A10)*5);FALSE)
You can copy this down, as needed...
Pay attention to your regional settings, you might need to change the separators in formula from ";" to ","

Thank you Catalin. B
Thats really nice of you