In A1 use =IF(ROW()<=number_of_samples,shipment_Id,"")
In B1 =IF(ROW()<=number_of_samples,shipment_Id,"")
and just copy down to your maximum number of samples of rows
--
HTH
Bob Phillips
"PPV" <[email protected]> wrote in message
news:[email protected]...
> My request sounds simple, but I have yet been unable to do it.
>
> I have a worksheet with a column that has a shipment id, say "H-5"
> I also have another column that lists the number of samples in that
> shipment, say 3.
>
> I need something that will create two new columns, one with the shipment
id
> and the other with the sample number. So based on the above entry it would
> create three rows:
> A B
> 1 H-5 1
> 2 H-5 2
> 3 H-5 3
>
> Since there were three samples, it created three entries for each sample
and
> then would continue on for each entry on the original worksheet, say H-6,
> five samples.
>
> Any suggestions would be greatly appreciated.
> Thanks,
> -Derek
Bookmarks