| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy rows of data (eliminating blank rows) from fixed layout
Something to add:
Second worksheet will be populated automatically when the data in sheet 1 is updated. Thank you. "Sweepea" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Eliminating Blank Rows | Excel Discussion (Misc queries) | |||
| Merge data rows at fixed ratio | Excel Discussion (Misc queries) | |||
| Get number of rows that data uses, including blank rows | Excel Discussion (Misc queries) | |||
| Get number of rows that data takes up, including blank rows | Excel Worksheet Functions | |||
| Copy rows of data to another worksheet where ReturnDate is blank | Excel Discussion (Misc queries) | |||
Hybrid Mode
