I have data in the excel sheet with .A column for OrderNo and B Column for
items
for that Order.


A B

ORD001 ITEM1
ITEM2
ITEM3

ORD002 ITEM4
ITEM1
ITEM5

There are more than thousand orders.I want search for an Order so that it
brings all items with it.
I cannot use filter in A column as it doesn't recognise blank cell.So Option
to
repeat order nos in A for every item involves a lot of data entry.
Any Solution ?