G
Guest
I have two sets of data, from which I am trying to extract values of one to
insert into the other. My problem is that for each value in my first set
there can be more than one value in the second set, and that the second set
of data can contain multiple rows.
Perhaps the following is a better illustration:
Data Set A:
A B C
D
Customer ID Type of Service #1 Type of Service #2 Type of Service #3
545
646
747
848
Data Set B
A B
Customer ID Type of Service
545 Oil Change
545 Tyres
646 Oil Change
646 Tyres
646 Filters
747 Oil Change
848 Tyres
848 Filters
I need to bring into my sheet for Data Set A all of the values for Service
Type from Data Set 2, with one row per Customer ID & multiple columns for
Service Type, one value per column. The problem is that the data in data set
two is arranged so that each Customer ID has multiple rows with one Service
Type per row.
I have some experience with HLOOKUP, although I am more familiar with
VLOOKUP, but it is offsetting the lookup that baffles me.
I feel sure that this is possible, but I just don't know where to start, and
as this is a problem that arises for me frequently it would be great to find
out once and for all how to resolve it.
Can anyone help?
Regards,
Dickie
insert into the other. My problem is that for each value in my first set
there can be more than one value in the second set, and that the second set
of data can contain multiple rows.
Perhaps the following is a better illustration:
Data Set A:
A B C
D
Customer ID Type of Service #1 Type of Service #2 Type of Service #3
545
646
747
848
Data Set B
A B
Customer ID Type of Service
545 Oil Change
545 Tyres
646 Oil Change
646 Tyres
646 Filters
747 Oil Change
848 Tyres
848 Filters
I need to bring into my sheet for Data Set A all of the values for Service
Type from Data Set 2, with one row per Customer ID & multiple columns for
Service Type, one value per column. The problem is that the data in data set
two is arranged so that each Customer ID has multiple rows with one Service
Type per row.
I have some experience with HLOOKUP, although I am more familiar with
VLOOKUP, but it is offsetting the lookup that baffles me.
I feel sure that this is possible, but I just don't know where to start, and
as this is a problem that arises for me frequently it would be great to find
out once and for all how to resolve it.
Can anyone help?
Regards,
Dickie