View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stratis stratis is offline
external usenet poster
 
Posts: 32
Default autogenerate multiple rows from single entries in different sheet

I want to generate a multi row spreadsheet from a single entries
ie
Sales1 state1 3
Sales2 state2 2
Sales3 state3 0
to become
Sales1 state1
Sales1 state1
Sales1 state1
Sales2 state2
Sales2 state2