Hi,
On sheet1 the data is oriented vertically as
A1
A2
A3
I'd like on sheet2 the data be oriented horizontally
A1 to A1
A2 to B1
A3 to B3
Can it be done? if so, how?
TIA
Olga
Excell 07

Copy the data from sheet1

Select A1 of sheet2 and paste specialtranspose.

Note: cannot be done if you have more than 16384 rows of data in column A

Also, I think you have a typo at A3 to B3.........maybe A3 to C1?


Gord Dibben MS Excel MVP

On Sun, 20 Apr 2008 19:55:12 +0200, "Olga" wrote:

Hi,
On sheet1 the data is oriented vertically as
A1
A2
A3
I'd like on sheet2 the data be oriented horizontally
A1 to A1
A2 to B1
A3 to B3
Can it be done? if so, how?
TIA
Olga
Excell 07

Thank you Gord,
The data is coming from a SQL query and it is text and money values. If I
copy A1 from sheet 1 and paste it as transpose on sheet2 works however, if I
drag A1 horizontally to fulfill the rest of the cells then, the information
is not coherent. Surly I'm doing some wrong.


"Gord Dibben" <gorddibbATshawDOTca escribió en el mensaje de noticias
...
Copy the data from sheet1

Select A1 of sheet2 and paste specialtranspose.

Note: cannot be done if you have more than 16384 rows of data in column A

Also, I think you have a typo at A3 to B3.........maybe A3 to C1?


Gord Dibben MS Excel MVP

On Sun, 20 Apr 2008 19:55:12 +0200, "Olga" wrote:

Hi,
On sheet1 the data is oriented vertically as
A1
A2
A3
I'd like on sheet2 the data be oriented horizontally
A1 to A1
A2 to B1
A3 to B3
Can it be done? if so, how?
TIA
Olga
Excell 07

"Surley I'm doing some wrong"

Yes, you are<g

Re-read the instructions................I did not say to copy A1 from sheet1

Select the data range on sheet1 and copy.

Select A1 on sheet2 and EditPaste SpecialTransposeOKEsc

No dragging needed. You are paste/transposing the copied range, not just one
cell.


Gord

On Sun, 20 Apr 2008 21:05:07 +0200, "Olga" wrote:

Thank you Gord,
The data is coming from a SQL query and it is text and money values. If I
copy A1 from sheet 1 and paste it as transpose on sheet2 works however, if I
drag A1 horizontally to fulfill the rest of the cells then, the information
is not coherent. Surly I'm doing some wrong.


"Gord Dibben" <gorddibbATshawDOTca escribió en el mensaje de noticias
.. .
Copy the data from sheet1

Select A1 of sheet2 and paste specialtranspose.

Note: cannot be done if you have more than 16384 rows of data in column A

Also, I think you have a typo at A3 to B3.........maybe A3 to C1?


Gord Dibben MS Excel MVP

On Sun, 20 Apr 2008 19:55:12 +0200, "Olga" wrote:

Hi,
On sheet1 the data is oriented vertically as
A1
A2
A3
I'd like on sheet2 the data be oriented horizontally
A1 to A1
A2 to B1
A3 to B3
Can it be done? if so, how?
TIA
Olga
Excell 07

Thank you very much, it worked. But how would sheet 2 update itself when
sheet 1 is updated refreshing the db connection?

"Gord Dibben" <gorddibbATshawDOTca escribió en el mensaje de noticias
...
"Surley I'm doing some wrong"

Yes, you are<g

Re-read the instructions................I did not say to copy A1 from
sheet1

Select the data range on sheet1 and copy.

Select A1 on sheet2 and EditPaste SpecialTransposeOKEsc

No dragging needed. You are paste/transposing the copied range, not just
one
cell.


Gord

On Sun, 20 Apr 2008 21:05:07 +0200, "Olga" wrote:

Thank you Gord,
The data is coming from a SQL query and it is text and money values. If I
copy A1 from sheet 1 and paste it as transpose on sheet2 works however, if
I
drag A1 horizontally to fulfill the rest of the cells then, the
information
is not coherent. Surly I'm doing some wrong.


"Gord Dibben" <gorddibbATshawDOTca escribió en el mensaje de noticias
. ..
Copy the data from sheet1

Select A1 of sheet2 and paste specialtranspose.

Note: cannot be done if you have more than 16384 rows of data in column
A

Also, I think you have a typo at A3 to B3.........maybe A3 to C1?


Gord Dibben MS Excel MVP

On Sun, 20 Apr 2008 19:55:12 +0200, "Olga" wrote:

Hi,
On sheet1 the data is oriented vertically as
A1
A2
A3
I'd like on sheet2 the data be oriented horizontally
A1 to A1
A2 to B1
A3 to B3
Can it be done? if so, how?
TIA
Olga
Excell 07

Sheet2 will not update itself using the manual transpose method we just did.

We will have to link the cells to the source range then tranpose those links.

Or write a macro to do the job after each query.

What is your original source range that will be transposed?

Is it consistent or variable range?


Gord

On Sun, 20 Apr 2008 23:54:53 +0200, "Olga" wrote:

Thank you very much, it worked. But how would sheet 2 update itself when
sheet 1 is updated refreshing the db connection?

"Gord Dibben" <gorddibbATshawDOTca escribió en el mensaje de noticias
.. .
"Surley I'm doing some wrong"

Yes, you are<g

Re-read the instructions................I did not say to copy A1 from
sheet1

Select the data range on sheet1 and copy.

Select A1 on sheet2 and EditPaste SpecialTransposeOKEsc

No dragging needed. You are paste/transposing the copied range, not just
one
cell.


Gord

On Sun, 20 Apr 2008 21:05:07 +0200, "Olga" wrote:

Thank you Gord,
The data is coming from a SQL query and it is text and money values. If I
copy A1 from sheet 1 and paste it as transpose on sheet2 works however, if
I
drag A1 horizontally to fulfill the rest of the cells then, the
information
is not coherent. Surly I'm doing some wrong.


"Gord Dibben" <gorddibbATshawDOTca escribió en el mensaje de noticias
...
Copy the data from sheet1

Select A1 of sheet2 and paste specialtranspose.

Note: cannot be done if you have more than 16384 rows of data in column
A

Also, I think you have a typo at A3 to B3.........maybe A3 to C1?


Gord Dibben MS Excel MVP

On Sun, 20 Apr 2008 19:55:12 +0200, "Olga" wrote:

Hi,
On sheet1 the data is oriented vertically as
A1
A2
A3
I'd like on sheet2 the data be oriented horizontally
A1 to A1
A2 to B1
A3 to B3
Can it be done? if so, how?
TIA
Olga
Excell 07