P
pidoling
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
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