| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rotating data
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
rotating data
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
rotating data
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
rotating data
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
rotating data
Thanks Max! Great help! :)
"Max" wrote: 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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
rotating data
Welcome, glad that did it for you
Thanks for the feedback -- Max Singapore http://savefile.com/projects/236895 Downloads:19,000 Files:362 Subscribers:62 xdemechanik --- "Frustrated!" wrote in message ... Thanks Max! Great help! :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rotating Data | Excel Discussion (Misc queries) | |||
| rotating a spreadsheet | Excel Discussion (Misc queries) | |||
| rotating list | Excel Worksheet Functions | |||
| Rotating Scroll Bar | Excel Discussion (Misc queries) | |||
| Rotating a chart, and more.. | Charts and Charting in Excel | |||
Linear Mode
