rotating data

  • Thread starter Thread starter Frustrated!
  • Start date Start date
F

Frustrated!

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
 
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?
 
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
 
Thanks Max! Great help! :)

Max said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array advance sum formula 3
Finding values in different rows/columns 1
Checking Column Status on closing excel - Macro Needed 2
looping colums and rows 11
Compare Two Workbooks 2
Inserting additional rows and only copying certain columns 1
Looping solver for recursive optimization 6
Convert multiple columns into one long row 1

Back
Top