ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   To take the cells in the same row and divide them in rows (https://www.excelbanter.com/excel-discussion-misc-queries/153447-take-cells-same-row-divide-them-rows.html)

[email protected]

To take the cells in the same row and divide them in rows
 
the same question like before, please answer me.


Bob I

To take the cells in the same row and divide them in rows
 
This isn't chat. Try a learning a little patience, and then use Copy,
Paste Special, Transpose.

wrote:

the same question like before, please answer me.



Peo Sjoblom

To take the cells in the same row and divide them in rows
 
He waited 2 minutes <bg

Peo


"Bob I" wrote in message
...
This isn't chat. Try a learning a little patience, and then use Copy,
Paste Special, Transpose.

wrote:

the same question like before, please answer me.





[email protected]

To take the cells in the same row and divide them in rows
 
On Aug 8, 2:02 pm, Bob I wrote:
This isn't chat. Try a learning a little patience, and then use Copy,
Paste Special, Transpose.

wrote:
the same question like before, please answer me.


the thing is that i taught that i did not explain my self right


Bob I

To take the cells in the same row and divide them in rows
 


wrote:

On Aug 8, 2:02 pm, Bob I wrote:

This isn't chat. Try a learning a little patience, and then use Copy,
Paste Special, Transpose.

wrote:

the same question like before, please answer me.



the thing is that i taught that i did not explain my self right


You use this box to explain what you are asking. The original solution
supplied remains the same, Copy, Paste Special, Transpose.


challa prabhu

To take the cells in the same row and divide them in rows
 
Hi,

Do the following;

1. Select the row and copy using the Edit menu.
2. Clck a cell in a different location. and then on the Edit menu, click
Paste Special.
The Paste Special Dialog box is displayed.
3. Select the Transpose check box.
4. Click Ok to return to view the worksheet to view the transposed row.

Challa Prabhu

" wrote:

the same question like before, please answer me.




All times are GMT +1. The time now is 03:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com