How to turn rows horizontally to form columns?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to transfer text from cells in a row so that they form a
single column. In other words is it possible to turn a row 90 degrees so that
the cells which were beside each other now are underneath each other.
 
Is it transposition you are referring to?

Highlight the cells, copy and go to paste special. The tranposition check
box is in the bottom right hand corner.
 
select the cells of that row suppose A1:G10, copy this range, right
click on A2
click paste special and at the end check the transpose option then
press ok.
you are done.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Vertical Database to Horizontal? 4
Hide columns based on row values 2
CF Row after CF applied to Column 4
using the =page! feature to transpose a row to column 0
Select rows which satisfy 2 criteria 16
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
taking numbers in vertical cells putting them in horizontal cells 3

Back
Top