View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
trishlee trishlee is offline
external usenet poster
 
Posts: 2
Default Paste with Blank Rows?

I have the following setup in worksheet 1:
Item Qty
Apples 5
Oranges 2
Bananas 10

I want it to appear in worksheet 2 as:
Item Qty
Apples 5
Strawberries
Oranges 2
Cherries
Lemons
Blueberries
Bananas 10
Peaches
Pears

Is there a way that I can get the values from worksheet 1 to worksheet 2
without have to cut and paste each of the individual values?