Closed

transform excel sheet combine some columns into one

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.

Skills: Excel, Data Processing

See more: excel merge cells vertically without losing data, combine columns in excel, excel combine columns into one list, how to put data from multiple columns into one column in excel, combine multiple columns in excel into one column, how to quickly stack multiple columns into one column in excel, excel combine multiple cells into one separated by comma, how to merge rows in excel, selected cell excel sheet using script, write data excel sheet aspnet, write domain user excel sheet, combine columns excel vba, combine columns excel using vba, vsto excel read write cell, excel sheet webpage cell webservice, java code write excel sheet mysql database, combine excel sheet vbs, write excel sheet aspnet, write program copy contents website excel sheet, copy website records excel sheet columns

About the Employer:
( 52 reviews ) Port Vila, Vanuatu

Project ID: #24615062

37 freelancers are bidding on average $18 for this job

editchamp

Hey, I have been freelancing as a expert for 9 years. I understand that what can I do.I look forward to hear from you soon. Thanks!

$10 USD in 2 days
(164 Reviews)
7.0
TechnoGuruu

Hi, Please chat with me, I will provide you a VBA macro with button to automate the data processing as per the description of the project. I have expertise in Excel, formulas, Excel VBA and finished many such projects More

$30 USD in 2 days
(86 Reviews)
6.0
mjanchi

All done. Contact me...............................................................................................................................

$30 USD in 1 day
(38 Reviews)
5.4
IgeS

Hi there, I can provide you a manual how to concatenate the data with similar criteria using formulas and method that will be applicable to both google sheet and excel. Please contact me if this is any of what you n More

$30 USD in 1 day
(18 Reviews)
4.7
paulodayto08

Hi, Good Day! I can do that but using MS Excel and Macro. Let me know if that's ok with you. Please message me to discuss more about the project. I am a Project Management officer for 8 years in Accenture and Project More

$30 USD in 1 day
(40 Reviews)
4.5
sobhad20

Hi, I have gone through your project description and i am very much interested in doing your project. Having good typing speed with careful and accurate to every details. I am sure i'll exceed your expectation. More

$10 USD in 1 day
(45 Reviews)
4.1
rajamajid1981

Hi there, Sir all done..................................... i have updated your google sheet please check. I have read the description you provided about the project; I am having 6+ years of experience More

$20 USD in 1 day
(1 Review)
3.6
Banze

I can help you in transform excel sheet combine some columns into one. I have read and understood all your initial requirements, and I feel, I would be the best choice for this project,. I am producing quality data ent More

$20 USD in 2 days
(2 Reviews)
2.5
chenshan91

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.

$10 USD in 1 day
(4 Reviews)
1.4
hiteshchavadaa

Hi there, Message Me Now... Start Immediately, Professional Expert, Check Review. I am interested in doing your work. i have read and understand your project description and also requirements. But I want to know mor More

$10 USD in 1 day
(1 Review)
1.0
S3oudyy

Am the best choice to make this job , i have an experience and qualified about this , and i will not regret you just contact me immediately

$10 USD in 5 days
(1 Review)
0.8
mohamedhamdy2001

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

$10 USD in 1 day
(1 Review)
0.3
Nawin2951

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..

$20 USD in 7 days
(0 Reviews)
0.0
lmeher

I have good knowledge in Ms office(excel). I can complete within the deadline. I have Good experience in using excel formulas

$20 USD in 7 days
(0 Reviews)
0.0
sharmaviivek86

Dear Sir Greetings!!! please note that i am an expert in excel, please provide the job i will complete it by today. Speed is the key with accuracy. i will put the formulas in it, so that for further use you can p More

$20 USD in 1 day
(0 Reviews)
0.0
sakibsaifi37

Hi There, I am Sakib saifi.I seen your Data processing project right now. So I already Read your All Instruction & Requirements. I am really an Expert Data Entry So, I'm very interested to do complete your project care More

$15 USD in 1 day
(0 Reviews)
0.0
farzanbashir1989

I am an expert in excel spreadsheets. I can develop criteria based tables, pivot tables, infographics etc. Time commitment and adherence to project scope is my way of working. I will guarantee complete honesty and cust More

$17 USD in 3 days
(0 Reviews)
0.0
talibilal342

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.

$20 USD in 1 day
(0 Reviews)
0.0
Bardevaibhav053

I will try to my best

$25 USD in 1 day
(0 Reviews)
0.0
navaskaniyath

I just read your project and i see it is easy to do. converting from pdf to word manually is so easy.i can do this data entry work 100% accurately.

$15 USD in 1 day
(0 Reviews)
0.0