rotating data
 

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

rotating data
 

use concatenate function

On Oct 14, 2:06*pm, Frustrated!
wrote:
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

rotating data
 

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?

"muddan madhu" wrote:

use concatenate function

On Oct 14, 2:06 pm, Frustrated!
wrote:
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

rotating data
 

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
---
"Frustrated!" wrote:
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?

rotating data
 

Thanks Max! Great help! :)

"Max" wrote:

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
---
"Frustrated!" wrote:
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?

rotating data
 

Welcome, glad that did it for you
Thanks for the feedback
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
"Frustrated!" wrote in message
...
Thanks Max! Great help! :)