Correct me if I'm wrong, but it appears to me that you want to transpose the
data in row 1 into column 1 and then sort on column 1. Is this correct?
Do you want to automate this for the future, or just do it this time?

"cretesupplies" wrote:

This is how i have the data
column1 column2 column3 column4
row1 1 2 3 4
row2 5 6 7 8
row3 9 10 11 12

And this how i would like to transform it with the most automated way i can.

column1 column2 column3 column4
row1 1
row2 2
row3 3
row4 4
row5 5 6 7 8
row6 9 10 11 12

Which means that i'd like Excel to insert new rows in order to paste the
"transposed" data and move the rest or the rows down.
I hope i was a bit more clear this time...and please excuse my not
proficient english!!!
Thank you in advance.

Stavros from CRETA SUPPLIES
instead of just