I'd fill those empty cells in column a with the previous value. And use
format|conditional formatting to hide the duplicated values (if I needed to).
Then I'd use data|Filter|autofilter.

If you want to try, see Debra Dalgleish's site:
http://www.contextures.com/xlDataEntry02.html
http://www.contextures.com/xlCondFor...html#Duplicate
and
http://www.contextures.com/xlautofilter01.html

(ps. I wouldn't use the format|conditional formatting--just in case I filtered
by another column and hid the topmost row of that group. I like to see all the
data.)

sk wrote:

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 ?

--

Dave Peterson