special type of rows to columns procedure

[cretesupplies]

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

 

[Barb R.]

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]

This is how i have the data

column1 column2 column3 column4
row1 OPEL FORD KIA BENZ
row2 YAMAHA BMW FIAT SKODA
row3 HYUNDAI CITROEN MG MAZDA

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

column1 column2 column3 column4
row1 OPEL
row2 FORD
row3 KIA
row4 BENZ
row2 YAMAHA BMW FIAT SKODA
row3 HYUNDAI CITROEN MG MAZDA

WITHOUT DISSRUPTING THE NATURAL FLOW OF DATA OF EACH ORIGINAL ROW.
i HOPE I WAS MORE CLEAR THIS TIME AND FOR FUTURE USE AS WELL..ALSO I'D LIKE
U TO EXCUSE THE CAPS BUT NOW IT IS ALREADY TOO LATE...HAHAHAHA

THANK U IN ADVANCE

sTAVROS

CRETA SUPPLIES

 

[Barb R.]

Those who post on these boards do it on their own time, FOR FREE. If we
don't get it done to your schedule, it's probably because we have some other
more pressing issues ourselves.