Transposing multiple columns to rows
 

I have a tranpose issue.

Current Data Display:
100 101
200 201
300 301

Needs to be displayed:
100 101 200 201 300 301

Marcus

Transposing multiple columns to rows
 

Assume data as posted is in A2:B2 down
Place this in C1:
=OFFSET($A$2,INT((COLUMNS($A:A)-1)/2),MOD(COLUMNS($A:A)-1,2))
Copy across as far as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik
---
"Pittman" wrote:
I have a tranpose issue.

Current Data Display:
100 101
200 201
300 301

Needs to be displayed:
100 101 200 201 300 301

Marcus

Transposing multiple columns to rows
 

Thanks Max that solved the problem. I am transposing this data from one file
to another how do I copy and paste this data and formula to a different file?
--
Marcus


"Max" wrote:

Assume data as posted is in A2:B2 down
Place this in C1:
=OFFSET($A$2,INT((COLUMNS($A:A)-1)/2),MOD(COLUMNS($A:A)-1,2))
Copy across as far as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik
---
"Pittman" wrote:
I have a tranpose issue.

Current Data Display:
100 101
200 201
300 301

Needs to be displayed:
100 101 200 201 300 301

Marcus

Transposing multiple columns to rows
 

Easy to adapt

If the source data earlier is in Sheet1, in A2:B2 down

Then in another sheet in the same book, say in Sheet2,
you could place this in any starting cell, say in B2:
=OFFSET(Sheet1!$A$2,INT((COLUMNS($A:A)-1)/2),MOD(COLUMNS($A:A)-1,2))
Copy B2 across as required

The only change required is to the source anchor cell, ie: Sheet1!$A$2

And if its to Sheet1 in Book2.xls
(this Book.xls must be open simultaneously)
then the expression in the start cell would look like:
=OFFSET([Book2]Sheet1!$A$2,INT((COLUMNS($A:A)-1)/2),MOD(COLUMNS($A:A)-1,2))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:54
xdemechanik
---
"Pittman" wrote:
Thanks Max that solved the problem. I am transposing this data from one file
to another how do I copy and paste this data and formula to a different file?
--
Marcus

Transposing multiple columns to rows
 

Thanks Max, This was very helpful.
--
Marcus


"Max" wrote:

Easy to adapt

If the source data earlier is in Sheet1, in A2:B2 down

Then in another sheet in the same book, say in Sheet2,
you could place this in any starting cell, say in B2:
=OFFSET(Sheet1!$A$2,INT((COLUMNS($A:A)-1)/2),MOD(COLUMNS($A:A)-1,2))
Copy B2 across as required

The only change required is to the source anchor cell, ie: Sheet1!$A$2

And if its to Sheet1 in Book2.xls
(this Book.xls must be open simultaneously)
then the expression in the start cell would look like:
=OFFSET([Book2]Sheet1!$A$2,INT((COLUMNS($A:A)-1)/2),MOD(COLUMNS($A:A)-1,2))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:54
xdemechanik
---
"Pittman" wrote:
Thanks Max that solved the problem. I am transposing this data from one file
to another how do I copy and paste this data and formula to a different file?
--
Marcus

Transposing multiple columns to rows
 

My pleasure`, Marcus.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:55
xdemechanik
---
"Pittman" wrote in message
...
Thanks Max, This was very helpful.
--
Marcus