Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i convert a row of data into a column in another excel wor.
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? |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I convert a date and time column to a time column | Excel Worksheet Functions | |||
How can I convert a data from multiple rows into 1 column? | Excel Worksheet Functions | |||
Linking sheets when sorting row and column data | Excel Worksheet Functions | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
how to convert multiple columns of data into one single column? | Excel Worksheet Functions |