|  | How can row data report into columns? | | |
| | | Louis |  |
|  Posted: Wed Sep 03, 2008 3:22 am Post subject: How can row data report into columns? |  |
I have a spreadsheet where data is input by row left to right: A1 thru Z1
etc.....
How can row data report into columns?
AA1 thru AA26 etc where A1 would go into cell AA1 and B1 would fill into AA2
etc? Any way to do this?
Thanks in advance,
Louis |
| |
| | | pub | |
| | Posted: Wed Sep 03, 2008 3:46 am Post subject: Re: How can row data report into columns? | |
"Louis" <a> wrote in news:5cqdnflHWtaqgiPVnZ2dnUVZ_iydnZ2d@suscom.com:
| Quote: | I have a spreadsheet where data is input by row left to right: A1 thru
Z1 etc.....
How can row data report into columns?
AA1 thru AA26 etc where A1 would go into cell AA1 and B1 would fill
into AA2 etc? Any way to do this?
Thanks in advance,
Louis
|
it sounds like you just want to "transpose"
- copy A1 to AZ1
- right click on AA1
- click paste special
- click transpose
that should do it |
| |
| | | pub | |
| | Posted: Wed Sep 03, 2008 3:49 am Post subject: Re: How can row data report into columns? | |
pub <puiblicstuff@home.com> wrote in news:mxpvk.28496$Rs1.8301
@newsfe08.iad:
| Quote: | "Louis" <a> wrote in news:5cqdnflHWtaqgiPVnZ2dnUVZ_iydnZ2d@suscom.com:
I have a spreadsheet where data is input by row left to right: A1 thru
Z1 etc.....
Louis
it sounds like you just want to "transpose"
- copy A1 to AZ1
- right click on AA1
- click paste special
- click transpose
that should do it
|
oops, i meant copy A1 to Z1 |
| |
| | | Guest | |
| | Posted: Wed Sep 03, 2008 6:43 am Post subject: Re: How can row data report into columns? | |
Instead of transpose one could use the following formula:
Asume data from B3:E3 need to be copied to F3:F7
F3=INDEX($B$3:$E$3;ROW(B3)-ROW($B$3)+1), now copy down till F7 |
| |
| | | spamlet | |
| | Posted: Wed Sep 03, 2008 4:58 pm Post subject: Re: How can row data report into columns? | |
"pub" <puiblicstuff@home.com> wrote in message
news:3Apvk.28497$Rs1.2716@newsfe08.iad...
| Quote: | pub <puiblicstuff@home.com> wrote in news:mxpvk.28496$Rs1.8301
@newsfe08.iad:
"Louis" <a> wrote in news:5cqdnflHWtaqgiPVnZ2dnUVZ_iydnZ2d@suscom.com:
I have a spreadsheet where data is input by row left to right: A1 thru
Z1 etc.....
Louis
it sounds like you just want to "transpose"
- copy A1 to AZ1
- right click on AA1
- click paste special
- click transpose
that should do it
oops, i meant copy A1 to Z1
|
Well, how's that for service:
Not been in this group for ages: then I have a question, and the answer is
right there in front of me without even having to ask!
'Transpose' - nice one.
Would have liked to have this option on the 'get data'/csv dialogue ie. to
select whether values should be inserted as rows or columns, but 'transpose'
does the job.
Cheers,
S |
| |
|
|
