Reorder the Column

[BhuSan]

Dear All,

I have some data which I need to rearrange in a different manner so that I can import this into another software for further processing.

My original data will be have 10 column of information and rows and rows of data below that. I used only 8 rows just for example in the attached file.

Now I need to rearrange the data in 8 columns. Please see the attached file for desired result.

One thing if my original data change the result column should also change.

Please help me on this excel formula.

Thanks for your help in advance.

 

[vletm]

BhuSan
Press [ ReOrder ]-button ...

 

[BhuSan]

BhuSan
Press [ ReOrder ]-button ...

You made my job so easy. This is what I expected. Thanks a lot.

If possible could you please explain the code. I was not able to follow.

 

[vletm]

BhuSan
Press [ Demo ReOrder ]-button ...
... then You can follow procedure.

Reset sheet2,
get number of columns,
copy sheet1 values one-by-one from left-top to right-bottom to sheet2,
if sheet2's x-coord is over 'number of column'
then continue from the beginning of next row.