P
pll
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.
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.