Hi dear members,

I have 2 sets of data here in excel. 1st set=> item price group 2nd set=> customer
Basically, what i would like to achieve is: each customer should have a set of item price group. for eg : please refer to combine data below
itempricegroup customer
a 1
b 2
c 3
d

this is what i would like to achieve. customer 1 is tagged to a, b, c, d and customer 2 is tagged to a, b, c, d...so forth. It depends on how many customers i have but each customer should be tagged to a, b, c, d.


combine
a 1
b 1
c 1
d 1
a 2
b 2
c 2
d 2
a 3
b 3
c 3
d 3

Thanks for all the help in advance.