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?