Moving Rows to Columns

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I have a text file that I am importing that has
information on multiple rows (each entry has three rows of
data). I would move each row of data into a column. Anyone
have any ideas/macros on how to do this?
 
Dear Paul

Select the row of data, Copy it, move to the cell of your
choice (I would recommend on a new worksheet).Edit/Paste
Special/Tick the transpose box.

Hope this helps

Paul Falla
 

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

Merging multiple columns into one column (dynamically) 1
Excel Help to copy information from one row at a time to another sheet 1
Text to columns 2
Move rows into columns 3
How to filter rows data based on background color of individual cells 1
How to move data from rows to columns 6
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
Getting Text data using the Data - Subtotal feature 1

Back
Top