I am trying to figure out how to set up a formula for the following
example:
Two different worksheets A and B

worksheet A: column A = ID, column b = service type

worksheet B: column A = ID, column b =service type(cleaning), column c
= service type(repair), column C = service type(delivery).

worksheet A can have the same id on multiple rows with a different
type of service for example
id, services ---- column header
123, cleaning
124, cleaning
123, repair
124, delivery

on Worksheet B, I want one id per row like this:
id, cleaning, repair, delivery ------column header
123, yes, yes, no

So baically I want one row per id on worksheet b going across.

Thanks,
Rob