View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
patc303 patc303 is offline
external usenet poster
 
Posts: 1
Default Need to create rows from columns

I have a spreadsheet that looks like this:

Name | item 1 | item 2 | item 3 (etc.)

I need to format it into:

Name | item 1
Name | item 2
Name | item 3

Does anyone know how I can do that?
Thank you -
Pat