Find Jobs
Hire Freelancers

Formula to combine data on different rows into one

$10-30 USD

Abgeschlossen
Veröffentlicht vor mehr als 6 Jahren

$10-30 USD

Bezahlt bei Lieferung
[SEE DATA SAMPLE First] I need to combine data on different rows into one. I've attached sample spreadsheet. I need a formula that merges all phone numbers into one row with the unique address in column 1. For example: {Row1} 123 Street 78229 2103692365 2103695263 2156325632 2365236956 (each space representing a new cell)
Projekt-ID: 14829160

Über das Projekt

44 Vorschläge
Remote Projekt
Aktiv vor 7 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
Vergeben an:
Avatar des Nutzers
Hi, I am Imran from Pakistan, I am ready to start right now and try to complete as soon as possible. I have great skills for related to Job, you can check my profile for my client review etc for your complete satisfaction. I have also good experience for Website designing, product listing for various forum, magenta, word press, PDF branding (like designing, Branding, editable PDF & conversion etc), web research and searching, Adobe Photoshop/ Corel graphic designing. I have ALISON certified for MS Excel, Excel & Formula, Powerpoint, Word & office 2010. 10 year computer operator and Administrator in an organization. My Freelancer profile and portfolio also show my experience. I am really interested in this project so please give me chance, I hope it will be nice experience for both of us. I will provide you best service in lowest budget with complete accuracy. ready to start now. I have very cooperative nature person and I always give preference to clients satisfaction Regards
$10 USD in 0 Tag
4,9 (210 Bewertungen)
6,6
6,6
44 Freelancer bieten im Durchschnitt $20 USD für diesen Auftrag
Avatar des Nutzers
Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. Relevant Skills and Experience Data Entry, Data Processing, Excel Proposed Milestones $30 USD - 1 If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
$30 USD in 1 Tag
4,9 (422 Bewertungen)
8,0
8,0
Avatar des Nutzers
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years of experience with excellent knowledge. please give me a chance to work on your project Proposed Milestones $25 USD - payment after work completion
$25 USD in 0 Tag
4,9 (364 Bewertungen)
8,1
8,1
Avatar des Nutzers
Respected Sir/Mam I will do any formula, function, formatting, calculation, modification, automation on Excel. PFA my previous automation works for reference. I hope to work with you. Thanks!! Relevant Skills and Experience Excel Proposed Milestones $25 USD - Project
$25 USD in 1 Tag
5,0 (202 Bewertungen)
7,8
7,8
Avatar des Nutzers
So ultimately you need all data within a single row. Right? Relevant Skills and Experience Excel Proposed Milestones $14 USD - .
$14 USD in 1 Tag
5,0 (399 Bewertungen)
7,6
7,6
Avatar des Nutzers
it's very simple just award to me project and send master sheet. Relevant Skills and Experience yes Proposed Milestones $15 USD - mil.
$15 USD in 0 Tag
4,9 (588 Bewertungen)
7,6
7,6
Avatar des Nutzers
Hello! My name is Irnes and I'm a data entry/web search specialist from Bosnia and Herzegovina. Relevant Skills and Experience My best skills are: - any type of data entry, data collection - MS Office related jobs - PDF conversion to any format - web search / internet research / web scraping Proposed Milestones $25 USD - milestone.
$25 USD in 1 Tag
5,0 (81 Bewertungen)
7,0
7,0
Avatar des Nutzers
Formula: D2&CHAR(10)&E2&CHAR(10)&F2 if Phone nos. are in D2, E2 & F2 and set cell format to wrap text. CSV files would not support saving after this kind of formula introduction & formatting change. Stay tuned, I'm still working on this proposal.
$10 USD in 0 Tag
5,0 (202 Bewertungen)
6,9
6,9
Avatar des Nutzers
Hi, I am very interested to your data entry project. I have enough experienced about your project. I have highly confident that i can do your project quickly & accuracy. Thanks Relevant Skills and Experience web search, web scraping, data mining, data extract etc. I have 5 years experience about your project. Proposed Milestones $25 USD - Milestone
$25 USD in 1 Tag
4,9 (62 Bewertungen)
6,4
6,4
Avatar des Nutzers
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/word/outlook VBA automation professional having 7+ years of experience and can do it with the required quality. Next steps: Lets discuss/validate the complete requirement, budget and I can start to get this done with required quality output. Lets discuss more online on chat. Thanks, Abhinav
$29 USD in 0 Tag
4,9 (165 Bewertungen)
6,5
6,5
Avatar des Nutzers
I know a formula through which I can easily solve your problem and it won't take more than 4-5 minute for me. Relevant Skills and Experience Excel, Data Processing Proposed Milestones $25 USD - m
$25 USD in 1 Tag
4,9 (82 Bewertungen)
6,1
6,1
Avatar des Nutzers
I have 7 years of experience this field.. I can automate this process by VBA or Formula whatever you desire.. You can see my profile for client reviews about me Relevant Skills and Experience Excel VBA Proposed Milestones $25 USD - only Looking for your response.
$25 USD in 1 Tag
4,8 (34 Bewertungen)
5,6
5,6
Avatar des Nutzers
Hi, This is a simple task: you can use either "concatenate", or the "&" sign. Happy to solve this issue for you for free. It should take us about 10 seconds. Relevant Skills and Experience I have 5 years excel experience at the Boston Consulting Group. Proposed Milestones $10 USD - delivered all at once- for free
$10 USD in 0 Tag
5,0 (6 Bewertungen)
4,2
4,2
Avatar des Nutzers
I have read you project requirements and I'm interested to work on it. I'll merger data as per your requirements using a formula. Waiting for your positive reply. Thank you Relevant Skills and Experience I have experience of using Excel formula. Proposed Milestones $10 USD - complete project
$10 USD in 1 Tag
4,5 (23 Bewertungen)
4,6
4,6
Avatar des Nutzers
I will surely get your project executed as required and you will get a superb result.I believe my dedication, experience, and advanced skills would be an ideal match for this position. Relevant Skills and Experience Data Entry, Data Processing, Excel Proposed Milestones $25 USD - Data Entry, Data Processing, Excel
$25 USD in 1 Tag
5,0 (14 Bewertungen)
3,3
3,3
Avatar des Nutzers
NOW , I can get it done in few hours, please contact me so I can start working on it immediately Relevant Skills and Experience I have more than 8 years of experience in developing / creating advanced excel sheets. Proposed Milestones $25 USD - For the project Initiation and closure Thanks for the clear requirements. :)
$20 USD in 1 Tag
5,0 (15 Bewertungen)
3,2
3,2
Avatar des Nutzers
Hi. I`m bidding for this project because I am a professional with lot of experience in MS Excel Habilidades y experiencia relevante I guarantee you an accurate job, proper formatting and fast delivery; all this in exchange of a fair rate that is perfectly adjusted to your budget. Htos propuestos $15 USD - To provide formulas for an Excel file
$15 USD in 0 Tag
4,7 (17 Bewertungen)
3,1
3,1
Avatar des Nutzers
I can definitely do this for you. Please contact and will get it done with in few minutes. Relevant Skills and Experience I am a developer trust me I know what would be the quickest way to apply this formula. Proposed Milestones $25 USD - formula added to the sheet
$25 USD in 1 Tag
5,0 (2 Bewertungen)
2,0
2,0
Avatar des Nutzers
here is the formula, I hope you will hire me please see this sheet https://docs.google.com/spreadsheets/d/13wW0Ap9IqR0fW5N-EV_PWQ4ET6xOBhEcXu0rlmjDo4Q/edit#gid=657661101 Relevant Skills and Experience excel Proposed Milestones $25 USD - full work how many numbers need to arrange?
$25 USD in 1 Tag
5,0 (10 Bewertungen)
2,1
2,1
Avatar des Nutzers
Hi there! I’m a proficient Data Entry professional. I am efficient enough to create formulas according to your need. Relevant Skills and Experience I'm adept at Excel and VBA. Proposed Milestones $10 USD - Job to be accomplished in no time If I have an opportunity to work with you, I can assure you of flawless delivery. Md. Shahin Iqbal
$10 USD in 1 Tag
5,0 (4 Bewertungen)
1,2
1,2
Avatar des Nutzers
A proposal has not yet been provided
$35 USD in 0 Tag
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von UNITED STATES
San Antonio, United States
5,0
15
Zahlungsmethode verifiziert
Mitglied seit Juli 14, 2016

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.