special type of rows to columns procedure

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

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
>
>
>

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

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.


"cretesupplies" wrote:

>
> 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
>