Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have data that was given to me in a csv that has each entry point in a row
going horizontally. But I need to export the data in a format with a header, so I need to get it into a vertical column. Can someone help me make this conversion happen - I am sure it is something simple. THanks in advance, |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Copy - Paste Special - Check Transpose...
-- HTH... Jim Thomlinson "Tripp K" wrote: I have data that was given to me in a csv that has each entry point in a row going horizontally. But I need to export the data in a format with a header, so I need to get it into a vertical column. Can someone help me make this conversion happen - I am sure it is something simple. THanks in advance, |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Copy, Paste Special, Transpose
Tripp K wrote: I have data that was given to me in a csv that has each entry point in a row going horizontally. But I need to export the data in a format with a header, so I need to get it into a vertical column. Can someone help me make this conversion happen - I am sure it is something simple. THanks in advance, |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dear Mr. Tripp
its is very easy to change the row data to column and as well column data to row with the help of paste special there is an excelent option " Transpose' use this : copy the data then go to the cell where u want to , right click, paste special , click Transpose option then enter the ok , u will get the transpose data copy paster special click Transpose -- Name : K.Prasad Inventory Controller CRYSTALGALLERY DUBAI "Tripp K" wrote: I have data that was given to me in a csv that has each entry point in a row going horizontally. But I need to export the data in a format with a header, so I need to get it into a vertical column. Can someone help me make this conversion happen - I am sure it is something simple. THanks in advance, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting columns into rows | Excel Discussion (Misc queries) | |||
Converting columns to rows | Excel Worksheet Functions | |||
(Again) Converting rows to columns | Excel Discussion (Misc queries) | |||
Converting Columns to Rows | Excel Worksheet Functions | |||
Converting Rows to Columns? | Excel Discussion (Misc queries) |