For anyone curious I ended up finding a solution myself much better than anything proposed here. It is posted in the Solution sheet at the original task link below.
I have this spreadsheet [login to view URL]
As you see options are repeated as a separate for for each model.
What I need is each option appearing as a single row only and each model the option applies to appearing as a comma separated list in a single cell next to each option.
For example instead of
ELECTRONICS GARMIN EAGLE 10 GARMIN FANTOM 18' RADAR
ELECTRONICS GARMIN EAGLE 8 GARMIN FANTOM 18' RADAR
ELECTRONICS GARMIN EAGLE 670 GARMIN FANTOM 18' RADAR
ELECTRONICS GARMIN NAVIGATOR 730 GARMIN FANTOM 18' RADAR
ELECTRONICS GARMIN NAVIGATOR 610 GARMIN FANTOM 18' RADAR
It should just have a single line like so
ELECTRONICS GARMIN EAGLE 10, EAGLE 8, EAGLE 670, NAVIGATOR 730, NAVIGATOR 610 GARMIN FANTOM 18' RADAR
I am looking for someone to apply some formula or another excel or google sheets function that would combine the rows as needed rather than use manual data entry to write them manually and supply back the updated sheet as well as show the formula or explain how it was done so I can do it myself for future such sheets.
37 freelancers are bidding on average $18 for this job
Hello. I am an expert in excel, Data Processing, etc. I can provide you excellent result. If you award me, I'll start to work soon. I am waiting for your reply. Thanks. Regards.
hello i combine this excel cell as one cell in short time and for low money. i can give you the attached one as a sample. please contact me for the sample
Hi there, I read your above description and I'm intereseted in your projects. I have 4 years of experience in photo and video editing,photoshop,translate,Youtube, and MS Office..
I am free and excited to work with you World is shut, me too looking for a project. Hope we will go ahead Relevant Skills and Experience I am BSC in electronics, teaching mathematics, highly engaged with computers.