I have a worksheet with lots of data and I need to combine some data into
cells using a check of adjacent cells.

Sample:

column
a b
rows1 115 D001
2 115 D005
3 118 F003
4 120 D002
5 120 D003
6 120 F002
7 120 F005
ETC

I need to have the formula check column a, rows 1 through whatever to see if
they are the same, if they are to combine the data in column b row 1 through
whatever into the first row column b.

sample out

columns
a b
rows 115 d001 d005
118 d003
120 d002 doo3 f002 f005

Can anyone figure out if this is possible and how I would go about doing it?

I have tried lots of ways and can't get it to work.

Thanks.

--
PLL