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