G
Guest
Search for same text in column D and find...
if column D1, D2 and D3 =
Mel Rosenfeld
Mel Rosenfeld
Mel Rosenfeld
then combine/concatenate corresponding cells in column A
A1, A2, A3 into cell A1
123 Main Street
55 Main Street
28 Main Street
so that cell A1 = 123 Main Street, 55 Main Street,28 Main Street
if column D1, D2 and D3 =
Mel Rosenfeld
Mel Rosenfeld
Mel Rosenfeld
then combine/concatenate corresponding cells in column A
A1, A2, A3 into cell A1
123 Main Street
55 Main Street
28 Main Street
so that cell A1 = 123 Main Street, 55 Main Street,28 Main Street