How to merge two cells for data validation drop down menu, I want second cocell

Copper Contributor
10 - Projects to increase capacity with a view to increasing sales volume10 - STC - Structural
20 - Projects for adjusting to market needs10 - MAR - Marginal
30 - Productivity Projects & Cost Reduction10 - Research Capacity Augmentation
41 - Environment and Prevention20 - GAM - Routings
42 - Sustainability20 - MOL - Molds
50 - Information System20 - EVO - Product Evolution and Innovation
80 - Distribution20 - QUA - Quality
 20 - CPL - Capacity Planning
 20 - MR20 - New Means of Research
 20 - PIL20 - Pre-Indus pilot of DORD
 30 - ENE - Energy
 30 - PRO - Productivity
 30 - EVL - Structural
 41 - AMI - Asbestos
 41 - ENV - Environment
 41 - PPH - Safety
 41 - PPI - Fire
 41 - SHE - Ergonomics/QVT
10 - Projects to increase capacity with a view to increasing sales volume10 - STC - Structural
20 - Projects for adjusting to market needs10 - MAR - Marginal
30 - Productivity Projects & Cost Reduction10 - Research Capacity Augmentation
41 - Environment and Prevention20 - GAM - Routings
42 - Sustainability20 - MOL - Molds
50 - Information System20 - EVO - Product Evolution and Innovation
80 - Distribution20 - QUA - Quality
 20 - CPL - Capacity Planning
 20 - MR20 - New Means of Research
 20 - PIL20 - Pre-Indus pilot of DORD
 30 - ENE - Energy
 30 - PRO - Productivity
 30 - EVL - Structural
 41 - AMI - Asbestos
 41 - ENV - Environment
 41 - PPH - Safety
 41 - PPI - Fire
 41 - SHE - Ergonomics/QVT
 41 - SHS - Equipment Safety
 41 - SHY - Hygiene
 42 - PCD - Maintenance on Machine
 42 - IFR - Maintenance on Building
 42 - 42MR - Replacement of Research Facility
 50 - PSI - IS IT Projects
 80 - DIS - Distribution
1 Reply

@kkchandana 

 

Two requests for you.

1) Please complete the sentence of what you want. Your original posting simply ends in mid-sentence

mathetes_0-1613997953183.png

 

2) Would you be so kind as to include the spreadsheet that you're copying from as part of your request, or a mock-up of it if the original contains confidential information. Otherwise you're asking us to create one, and it might not be as useful as your own original.