View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Copy info from one excel spreadsheet to an excel template

CopyPaste SpecialTransposeOKEsc


Gord Dibben MS Excel MVP


On Wed, 21 Oct 2009 06:41:01 -0700, TB@work
wrote:

I have exported info from a program at work to an excel spreadsheet. This
spreadsheet does not come out in the format I am looking for. This
spreadsheet lists info from one entry in multiple rows. I'm looking to have
all this info from one entry in multiple columns not rows. Is there a way to
export the data from the excel spreadsheet to another excel spreadsheet in
the format I am looking for?