rotating data

F

Frustrated!

Is there a way to rotate info from a range for example:

10 134 - 1205 2.72 CELL1 FALSE FALSE
10 134 - 1402 0.12 CELL1 FALSE FALSE
into a single row where the info from above will display as follow


10 134 - 1205 2.72 CELL1 FALSE FALSE 10 134 - 1402 0.12 CELL1 FALSE FALSE
 
F

Frustrated!

Thanks for your reply, but would this still work for converting multiple rows
into multiple columns and one row in the same format described for example:-

sal firstname surname
sal firstname surname
sal firstname surname

into:-

sal firstname surname sal firstname surname sal firstname surname

We are talking 20+ rows?
 
M

Max

Assuming your data is in cols A to C, from row1 down
Place this in D1:
=OFFSET($A$2,INT((COLUMNS($A:A)-1)/3),MOD(COLUMNS($A:A)-1,3),)
Copy D1 across as far as required to exhaust the data horizontally
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:61
xdemechanik
 
F

Frustrated!

Thanks Max! Great help! :)

Max said:
Assuming your data is in cols A to C, from row1 down
Place this in D1:
=OFFSET($A$2,INT((COLUMNS($A:A)-1)/3),MOD(COLUMNS($A:A)-1,3),)
Copy D1 across as far as required to exhaust the data horizontally
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:61
xdemechanik
Click to expand...
 
Top