Text to columns

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

Guest

I have a worksheet that has the data in rows but I need them in columns. Is
there a way that I can get the data to columns? ( example Rows 1,2,3 need
to be Row 1 columns A, B C - Rows 4,5,6 need to be Row 2 columns A,B, C etc)
 
hi,
If i understand you correctly, i think you want to use the paste special -
transposed.
On the toolbar go Edit>PasteSpecial. in the dialog box(near the bottom on
mine), check Transposed. This will paste data in rows into columns.

Good luck

FSt1
 
Thanks

FSt1 said:
hi,
If i understand you correctly, i think you want to use the paste special -
transposed.
On the toolbar go Edit>PasteSpecial. in the dialog box(near the bottom on
mine), check Transposed. This will paste data in rows into columns.

Good luck

FSt1
Click to expand...
 

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

Having Blank Cells, etc. ? 1
Multiple SUM's in a column 15
Excel Help to copy information from one row at a time to another sheet 1
counting blank cells within two columns 2
Change the properties of the worksheet row or column header bars 6
Transpose, but how? 0
Increasing columns 1
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

Back
Top