I have 2 sheets with Item Numbers, Quantities, And Descritpions.
The Description of the Item May be 1 row or Multiple rows.

On a third sheet, I need to consolidate the list from "sheet 1" and "Sheet
2" elimating the Item Number and Quantity if the Description is more than 1
Line.

Note:
On the First 2 Sheets I have a formula for the Item Number, similar to:
=IF(B2="","",MAX($A$2:A10)+1) , So that once a QNTY is entered in Column "B"
it gives a new Item Number. Allowing "Blank" rows and/or "Multi-Line
Descriptions".

I am not sure if you can make sense of this example below, But If you can I
would appreciate it.
Thanks in advance.


"Sheet 1"
A B C
1 Item# QNTY Description
2 1 10 Apple
3 Red
4
5 2 11 Apple
6 Green
7
8
9
10 3 1 Orange

"Sheet 2"
A B C
1 Item# QNTY Description
2 4 2 Orange
3 Rotten
4
5 5 1 Banana

€œSheet 3€�
A B C
1 Item# QNTY Description
2 1 10 Apple
3 Red
4 2 11 Apple
5 Green
6 3 1 Orange
7 4 2 Orange
8 Rotten
9 5 1 Banana