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

%3CLINGO-SUB%20id%3D%22lingo-sub-2154686%22%20slang%3D%22en-US%22%3EHow%20to%20merge%20two%20cells%20for%20data%20validation%20drop%20down%20menu%2C%20I%20want%20second%20cocell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2154686%22%20slang%3D%22en-US%22%3E%3CTABLE%20width%3D%22966%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E10%20-%20Projects%20to%20increase%20capacity%20with%20a%20view%20to%20increasing%20sales%20volume%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E10%20-%20STC%20-%20Structural%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E20%20-%20Projects%20for%20adjusting%20to%20market%20needs%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E10%20-%20MAR%20-%20Marginal%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E30%20-%20Productivity%20Projects%20%26amp%3B%20Cost%20Reduction%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E10%20-%20Research%20Capacity%20Augmentation%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E41%20-%20Environment%20and%20Prevention%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E20%20-%20GAM%20-%20Routings%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E42%20-%20Sustainability%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E20%20-%20MOL%20-%20Molds%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E50%20-%20Information%20System%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E20%20-%20EVO%20-%20Product%20Evolution%20and%20Innovation%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E80%20-%20Distribution%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E20%20-%20QUA%20-%20Quality%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E20%20-%20CPL%20-%20Capacity%20Planning%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E20%20-%20MR20%20-%20New%20Means%20of%20Research%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E20%20-%20PIL20%20-%20Pre-Indus%20pilot%20of%20DORD%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E30%20-%20ENE%20-%20Energy%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E30%20-%20PRO%20-%20Productivity%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E30%20-%20EVL%20-%20Structural%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E41%20-%20AMI%20-%20Asbestos%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E41%20-%20ENV%20-%20Environment%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E41%20-%20PPH%20-%20Safety%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E41%20-%20PPI%20-%20Fire%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E41%20-%20SHE%20-%20Ergonomics%2FQVT%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E10%20-%20Projects%20to%20increase%20capacity%20with%20a%20view%20to%20increasing%20sales%20volume%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E10%20-%20STC%20-%20Structural%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E20%20-%20Projects%20for%20adjusting%20to%20market%20needs%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E10%20-%20MAR%20-%20Marginal%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E30%20-%20Productivity%20Projects%20%26amp%3B%20Cost%20Reduction%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E10%20-%20Research%20Capacity%20Augmentation%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E41%20-%20Environment%20and%20Prevention%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E20%20-%20GAM%20-%20Routings%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E42%20-%20Sustainability%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E20%20-%20MOL%20-%20Molds%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E50%20-%20Information%20System%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E20%20-%20EVO%20-%20Product%20Evolution%20and%20Innovation%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E80%20-%20Distribution%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E20%20-%20QUA%20-%20Quality%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E20%20-%20CPL%20-%20Capacity%20Planning%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E20%20-%20MR20%20-%20New%20Means%20of%20Research%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E20%20-%20PIL20%20-%20Pre-Indus%20pilot%20of%20DORD%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E30%20-%20ENE%20-%20Energy%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E30%20-%20PRO%20-%20Productivity%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E30%20-%20EVL%20-%20Structural%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E41%20-%20AMI%20-%20Asbestos%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E41%20-%20ENV%20-%20Environment%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E41%20-%20PPH%20-%20Safety%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E41%20-%20PPI%20-%20Fire%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E41%20-%20SHE%20-%20Ergonomics%2FQVT%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E41%20-%20SHS%20-%20Equipment%20Safety%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E41%20-%20SHY%20-%20Hygiene%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E42%20-%20PCD%20-%20Maintenance%20on%20Machine%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E42%20-%20IFR%20-%20Maintenance%20on%20Building%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E42%20-%2042MR%20-%20Replacement%20of%20Research%20Facility%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E50%20-%20PSI%20-%20IS%20IT%20Projects%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22421%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22545%22%3E80%20-%20DIS%20-%20Distribution%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2154686%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2155524%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20merge%20two%20cells%20for%20data%20validation%20drop%20down%20menu%2C%20I%20want%20second%20cocell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2155524%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F974183%22%20target%3D%22_blank%22%3E%40kkchandana%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETwo%20requests%20for%20you.%3C%2FP%3E%3CP%3E1)%20Please%20complete%20the%20sentence%20of%20what%20you%20want.%20Your%20original%20posting%20simply%20ends%20in%20mid-sentence%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mathetes_0-1613997953183.png%22%20style%3D%22width%3A%20632px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F256476i2AF65C26E9E4F1B5%2Fimage-dimensions%2F632x29%3Fv%3D1.0%22%20width%3D%22632%22%20height%3D%2229%22%20role%3D%22button%22%20title%3D%22mathetes_0-1613997953183.png%22%20alt%3D%22mathetes_0-1613997953183.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2)%20Would%20you%20be%20so%20kind%20as%20to%20include%20the%20spreadsheet%20that%20you're%20copying%20from%20as%20part%20of%20your%20request%2C%20or%20a%20mock-up%20of%20it%20if%20the%20original%20contains%20confidential%20information.%20Otherwise%20you're%20asking%20us%20to%20create%20one%2C%20and%20it%20might%20not%20be%20as%20useful%20as%20your%20own%20original.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
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.