Thread: Copy rows of data (eliminating blank rows) from fixed layout
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sweepea Sweepea is offline
external usenet poster
  
Posts: 28
Default Copy rows of data (eliminating blank rows) from fixed layout
Worksheet 1 with fixed layout but random #s of rows for each category:

CategoryFruit:
Apple 1
<blank row
<blank row
Orange 2
<blank row

CategoryDrink:
Milk 3
<blank row
Soda 4
<blank row

Desired result on another worksheet with no blank rows:

Apple 1 CategoryFruit
Orange 2 CategoryFruit
Milk 3 CategoryDrink
Soda 4 CategoryDrink

Hope this makes sense. Please help!
Reply With QuoteReply With Quote