I have a heading in column A. There are several transactions listed in
columns B,C,D etc. (there are several rows of these under each column A
heading) I want to extend all items under main heading In column A into one
long row. I have heard the term "drop column", but cannot get that to work.
Basically I want the spreadsheet to have more columns that rows. Right now
it is the other way around.

do you mean : transpose?
convert rows to columns and vice versa?

"Brenda" wrote in message
...
I have a heading in column A. There are several transactions listed in
columns B,C,D etc. (there are several rows of these under each column A
heading) I want to extend all items under main heading In column A into
one
long row. I have heard the term "drop column", but cannot get that to
work.
Basically I want the spreadsheet to have more columns that rows. Right
now
it is the other way around.

If you are using XL2003 or earlier, there is a limit of 256 columns -
are you sure you won't exceed this by combining multiple records
together?

I think it would be better to aim for your data to be only two columns
wide and many rows long, with your "header" in column A appearing on
every row for which the transaction applies. This depends on exactly
what is in columns B,C,D etc, but you can easily summarise the data
from such a simple table using SUMIF (perhaps on a second sheet).

Hope this helps.

Pete

On Oct 8, 8:50 pm, Brenda wrote:
I have a heading in column A. There are several transactions listed in
columns B,C,D etc. (there are several rows of these under each column A
heading) I want to extend all items under main heading In column A into one
long row. I have heard the term "drop column", but cannot get that to work.
Basically I want the spreadsheet to have more columns that rows. Right now
it is the other way around.

or maybe he thinks about joining all text into one! but one text can't be
longer than 32000 characters!
and, it is not possible to see more than 255 characters in column (max width
is 255).
so...
interesting idea....

"Pete_UK" wrote in message
oups.com...
If you are using XL2003 or earlier, there is a limit of 256 columns -
are you sure you won't exceed this by combining multiple records
together?

I think it would be better to aim for your data to be only two columns
wide and many rows long, with your "header" in column A appearing on
every row for which the transaction applies. This depends on exactly
what is in columns B,C,D etc, but you can easily summarise the data
from such a simple table using SUMIF (perhaps on a second sheet).

Hope this helps.

Pete

On Oct 8, 8:50 pm, Brenda wrote:
I have a heading in column A. There are several transactions listed in
columns B,C,D etc. (there are several rows of these under each column A
heading) I want to extend all items under main heading In column A into
one
long row. I have heard the term "drop column", but cannot get that to
work.
Basically I want the spreadsheet to have more columns that rows. Right
now
it is the other way around.

Sasa

It is actually possible to see 1024 characters in a cell.

More if you add an Alt + Enter every 100 characters and set cell to wrap text
and row to autofit.


Gord Dibben MS Excel MVP

On Tue, 9 Oct 2007 21:56:05 +0200, "Sasa Stankovic" wrote:

or maybe he thinks about joining all text into one! but one text can't be
longer than 32000 characters!
and, it is not possible to see more than 255 characters in column (max width
is 255).
so...
interesting idea....

"Pete_UK" wrote in message
roups.com...
If you are using XL2003 or earlier, there is a limit of 256 columns -
are you sure you won't exceed this by combining multiple records
together?

I think it would be better to aim for your data to be only two columns
wide and many rows long, with your "header" in column A appearing on
every row for which the transaction applies. This depends on exactly
what is in columns B,C,D etc, but you can easily summarise the data
from such a simple table using SUMIF (perhaps on a second sheet).

Hope this helps.

Pete

On Oct 8, 8:50 pm, Brenda wrote:
I have a heading in column A. There are several transactions listed in
columns B,C,D etc. (there are several rows of these under each column A
heading) I want to extend all items under main heading In column A into
one
long row. I have heard the term "drop column", but cannot get that to
work.
Basically I want the spreadsheet to have more columns that rows. Right
now
it is the other way around.