| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert data in excel from A1 to A20 to A1,B1,C1;D1etc
-- Bev |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert data in excel from A1 to A20 to A1,B1,C1;D1etc
--Select A1:A20 and copy the range.
--Select cell B1Right clickPasteSpecial check 'Transpose' and click OK. --Delete Column A -- Jacob "Bev" wrote: -- Bev |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert excel data to dBaseIII | New Users to Excel | |||
| Convert PDF table data to Excel | Excel Discussion (Misc queries) | |||
| HOW CAN I CONVERT DATA FROM PDF TO EXCEL | Excel Discussion (Misc queries) | |||
| I want to convert word column data to excel row data to sort addre | Excel Discussion (Misc queries) | |||
| can i convert data copied as an image into data in excel ? | Excel Worksheet Functions | |||
![Bev[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
