Data manipulation problem

[uaegatts]

I have a worksheet with 3000 columns and two rows and would like to cut it into 2 row 50 column chunks and shift them down then move the even rows up and make it into a 100 column instead 50. can anyone help me with this please.

[Abdul Basit]

Dear Bro,

I am not understand what are you saying.. i if you want to change your column in row/row in column so simple. is that. cut your data and right click mouse and go on "paste special" and thick the transpose and click O.K,

Regards,

Abdul Basit