how do i convert a row of data into a column in another excel wor.

G

Guest

I want to convert a row of financial data for individuals into a column. For
example, convert:
Name Jan 2/05 Jan 9/05 Jan 16/05
....... Total
John Smith $5.00 $10.00 $15.00
$30.00

to:
Name John Smith
Jan 2/05 $5.00
Jan 9/05 $10.00
Jan 16/05 $15.00
..
..
..
..
Total $30.00

Can anyone help?
 
J

Jurek

1. Select all data you want to convert.
2. Edit > Copy
3 Set the cursor in the place you want to put your data
4 Edit > Paste Special > Transposition

best regards
Jurek
 

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

Using a range of dates to add data in a different column? 2
How do I create all columns in a macro. 2
Importing a space-delimited txt. file right-justified into Excel 2
Putting subtotals in $ descending order 1
Another Sumproduct & #N/A problem 3
How do I put multuple columns in a report 1
How do I compare in between two worksheets? 1
repeated conversion of data summarized into rows and columns 4

Top