Copy rows of data (eliminating blank rows) from fixed layout

G

Guest

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!
 
G

Guest

Something to add:

Second worksheet will be populated automatically when the data in sheet 1 is
updated.

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I reshuffle some column data based on a coding scheme? 9
copy from one sheet to another and skip the blank rows 3
series of sums in a long spreadsheet 1
Excel Concatenate with line breaks but ignore blank cells 3
Populate Data In Rows 9
insert row when sum of values equals 100 3
Combining data from multiple rows 2
Data sort seperate by blank row 1

Top