View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default field names for print merge

Cant you transpose the data in ColA and save as .csv.

Copy the cells say A1:A10Select cell B1Right
clickPasteSpecialTransposeOK; and delete Column A

If this post helps click Yes
---------------
Jacob Skaria


"Robert" wrote:

I am using Excel 2007 and want to create a .csv file to be used as a print
merge file for Corel Draw x4. At present, Corel reads the text in Row 1 as
field names and I need it to read the text in Column A as the field names.
How do I achieve this?