| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| Converting Columns to Rows | Excel Worksheet Functions | |||
| How do I lookup values from rows and columns Simultaneously | Excel Worksheet Functions | |||
| repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
| interchange columns with rows | Excel Discussion (Misc queries) | |||
Linear Mode
