Ditutup

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.

Kemahiran: Excel, Pemprosesan Data

Lihat lagi: 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

Tentang Majikan:
( 52 ulasan ) Port Vila, Vanuatu

ID Projek: #24615062

39 pekerja bebas membida secara purata $18 untuk pekerjaan ini

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 dalam 2 hari
(164 Ulasan)
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 Lagi

$30 USD dalam 2 hari
(86 Ulasan)
6.0
mjanchi

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

$30 USD dalam sehari
(38 Ulasan)
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 Lagi

$30 USD dalam sehari
(17 Ulasan)
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 Lagi

$30 USD dalam sehari
(40 Ulasan)
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. Lagi

$10 USD dalam sehari
(45 Ulasan)
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 Lagi

$20 USD dalam sehari
(1 Ulasan)
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 Lagi

$20 USD dalam 2 hari
(2 Ulasan)
2.4
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 dalam sehari
(2 Ulasan)
0.9
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 Lagi

$10 USD dalam sehari
(1 Ulasan)
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 dalam 5 hari
(1 Ulasan)
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 dalam sehari
(1 Ulasan)
0.3
asadiqali

Hi I have been working with excel for the past 10 years and could complete your project within the stipulated time.

$11 USD dalam 2 hari
(0 Ulasan)
0.0
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 dalam 7 hari
(0 Ulasan)
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 dalam 7 hari
(0 Ulasan)
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 Lagi

$20 USD dalam sehari
(0 Ulasan)
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 Lagi

$15 USD dalam sehari
(0 Ulasan)
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 Lagi

$17 USD dalam 3 hari
(0 Ulasan)
0.0
shashankself

Hi, my name is Shashank Pandey I can complete your project as soon as possible you can trust on me I assure you that you will be completely satisfied with my work.

$20 USD dalam 7 hari
(0 Ulasan)
0.0
Bardevaibhav053

I will try to my best

$25 USD dalam sehari
(0 Ulasan)
0.0