"Paste Special / Transpose" problem
 

Hello,

I want to take a list of variable names in a column and transpose it into a
row so it corellates against some previously recorded columns of variables
and their data.

Basically, I can't get the Paste Special / Transpose option to do its
business here!

I highlight the column, copy it, then higlight the cell I want my new row to
start, select Paste Special / Transpose, and then get the message "...the
copy area and the paste area are not the same size and shape..."

- well , of course not! But that wasn't stipulated in the instructions in
the help file, all it said was select the first cell where you want the row
to start.

How do I get this working, am I overlooking something obvious?

"Paste Special / Transpose" problem
 

hi.
that is the way it's suppose to work. the only thing i can think of is....
how may items in the list you are transposing? does it exceed avaible columns?

regards.
FSt1

"M_Hopwood" wrote:

Hello,

I want to take a list of variable names in a column and transpose it into a
row so it corellates against some previously recorded columns of variables
and their data.

Basically, I can't get the Paste Special / Transpose option to do its
business here!

I highlight the column, copy it, then higlight the cell I want my new row to
start, select Paste Special / Transpose, and then get the message "...the
copy area and the paste area are not the same size and shape..."

- well , of course not! But that wasn't stipulated in the instructions in
the help file, all it said was select the first cell where you want the row
to start.

How do I get this working, am I overlooking something obvious?

"Paste Special / Transpose" problem
 

Yes, I see now... cutting it into sections does indeed work.

I didn't think I'd exceeded the available columns but that seems to be the
answer!!!

"FSt1" wrote:

hi.
that is the way it's suppose to work. the only thing i can think of is....
how may items in the list you are transposing? does it exceed avaible columns?

regards.
FSt1

"M_Hopwood" wrote:

Hello,

I want to take a list of variable names in a column and transpose it into a
row so it corellates against some previously recorded columns of variables
and their data.

Basically, I can't get the Paste Special / Transpose option to do its
business here!

I highlight the column, copy it, then higlight the cell I want my new row to
start, select Paste Special / Transpose, and then get the message "...the
copy area and the paste area are not the same size and shape..."

- well , of course not! But that wasn't stipulated in the instructions in
the help file, all it said was select the first cell where you want the row
to start.

How do I get this working, am I overlooking something obvious?

"Paste Special / Transpose" problem
 

glad to help.
regards
FSt1

"M_Hopwood" wrote:

Yes, I see now... cutting it into sections does indeed work.

I didn't think I'd exceeded the available columns but that seems to be the
answer!!!

"FSt1" wrote:

hi.
that is the way it's suppose to work. the only thing i can think of is....
how may items in the list you are transposing? does it exceed avaible columns?

regards.
FSt1

"M_Hopwood" wrote:

Hello,

I want to take a list of variable names in a column and transpose it into a
row so it corellates against some previously recorded columns of variables
and their data.

Basically, I can't get the Paste Special / Transpose option to do its
business here!

I highlight the column, copy it, then higlight the cell I want my new row to
start, select Paste Special / Transpose, and then get the message "...the
copy area and the paste area are not the same size and shape..."

- well , of course not! But that wasn't stipulated in the instructions in
the help file, all it said was select the first cell where you want the row
to start.

How do I get this working, am I overlooking something obvious?