Are you looking for something like this:

create table tblOrders (OrderID int, City varchar(100))

go

insert into tblOrders values ('11111','New York')

insert into tblOrders values ('11111','')

insert into tblOrders values ('22222','London')

insert into tblOrders values ('33333','')

insert...