Hi All,
I am trying to do something reasonably complicated in excel, and not sure what way I should do it.
I basically have a list of car parts but there are a lot of part numbers that apply to multiple vehicles.
I have a Make, Model, Submodel, Product Code Column (plus lots more - but these 4 are the main ones of concern.
An example will be:
Make,Model,Submodal,Product Code
Ford,Focus,Mk1,000001
Ford,Focus,MK2,000001
Ford,Focus,MK3,000001
Audi,A1,1.2,000001
Audi,A4,1.4,000001
And so on.
What I would like, is to merge all of the makes, models, and submodals so they appear pipe seperated in a single cell (for each), where they have the same product code).
So the example above would look like.
Make,Model,Submodal,Product Code
Ford|Audi,Focus|A1|A4,Mk1|MK2|MK3|1.2|1.4,000001
Does that make sense?
Can anyone suggest what I can do please?
Thanks so much in advance!
Craig
I am trying to do something reasonably complicated in excel, and not sure what way I should do it.
I basically have a list of car parts but there are a lot of part numbers that apply to multiple vehicles.
I have a Make, Model, Submodel, Product Code Column (plus lots more - but these 4 are the main ones of concern.
An example will be:
Make,Model,Submodal,Product Code
Ford,Focus,Mk1,000001
Ford,Focus,MK2,000001
Ford,Focus,MK3,000001
Audi,A1,1.2,000001
Audi,A4,1.4,000001
And so on.
What I would like, is to merge all of the makes, models, and submodals so they appear pipe seperated in a single cell (for each), where they have the same product code).
So the example above would look like.
Make,Model,Submodal,Product Code
Ford|Audi,Focus|A1|A4,Mk1|MK2|MK3|1.2|1.4,000001
Does that make sense?
Can anyone suggest what I can do please?
Thanks so much in advance!
Craig