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