Transform excel list (specific data to be repeated on left side)

$10-30 USD

Completed

Posted

over 2 years ago

$10-30 USD

Paid on delivery

**See attachments for complete view **Important: new raw data will be pasted from time to time. So, the formulas and automation should be ready to transform new raw data as soon as pasted. Structure will be therefore the same as explained in the attachments. 1. The report shows a list of events to each person 2. It is structured to show the person’s name first and right below the events associated to this person. 3. After a set of rows, a new person’s name will be displayed and – again – right below to it the events associated to the person. 4. It is being required through this development to show the person names and id left to each row event. a. Please do use formulas from excel itself and do not use other exe. software that must not run my pc environment. I suggest you create a 2nd tab in the Excel mirroring the 1st tab. In the 1st tab raw data should be pasted and in the 2nd tab the formulas/automations should run to deliver the transformed list. b. Macro can be used, but if it can be avoided and just work with formulas that is better.

Excel

Project ID: 32673420

About the project

33 proposals

Remote project

Active 2 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@JulesWilcox

Hi - I have looked at the spreadsheet and as an experiment have updated it with formulas to populate new columns 1 and 2 per your specification. Nice and easy.

$10 USD in 1 day

5.0

(1 review)

0.0

33 freelancers are bidding on average $20 USD for this job

@ksriniravi

Greetings! For accomplishing the end goal, formulas alone are not sufficient (since you want to use this as a template and paste new data in future). Macros have to be used. I have some free time now - I am developing a macro. If you can initiate a chat, I can share the completed macro. If it works as per your satisfaction, you can award the project and pay me. Have a Great Day! Srinivasan

$20 USD in 1 day

5.0

(218 reviews)

7.0

@rohitagarberg

Hi there..can do this project for you...will start immediately working on it.... have read your project and understood..i am an expert in excel..thanks!!

$30 USD in 1 day

5.0

(405 reviews)

6.7

@kayemhussain

Dear hiring manager,, Fully understand your requirements & already i saw your attached Doc and XL file, I can provide you Transform excel list (specific data to be repeated on left side) .understood what you require. I can do this project with 100% accuracy right now. I want to send you sample tamlate because your satisfaction is my pride. I am the best freelancer for your job. Choose me and I will deliver within right time. I can get this done for you. Thank you M A Kayem Hussain

$20 USD in 1 day

4.9

(69 reviews)

6.1

@Ayo25

Hello, I am a native English Virtual assistant with a wide array of skills. I have worked remotely on several projects on freelancer helping my employers achieve their desired goals and I would love to do the same for you. I am well versed in article writing, Ms excel and data entry. I am also skilled in email handling and setting up meetings for clients. I am very hardworking and dedicated and I am available either part-time or full time. Please check out my portfolio for my past projects and reviews. Looking forward to working for you. Thanks

$30 USD in 1 day

5.0

(15 reviews)

5.9

@hamidr2020

Hi, I have read the instructions and checked the spreadsheet. I can transform the list with the excel formulas as per your requirements. I am an Excel expert. You can check my reviews for quality of work and client satisfaction. Looking forward to working with you. Thanks, Hamid

$21 USD in 1 day

5.0

(47 reviews)

5.2

@designer504

Hello, I am ready to start right now. I can professionally work on your project according to your requirements. I am an expert in EXCEL DATA ENTRY, CSV Editing, PDF, Digitization, WORD, Scan to Text with 10 years experience. I ensure i will complete the task successfully with a very short time. I have done many similar projects like this you can see an example of one of those projects in my portfolio here: https://www.freelancer.com/u/designer504 My motto has always been - an essential quality not quantity. With good communication and mood called together a good design! Hope you will contact me and we will work together. Thanks! and be safe,

$30 USD in 1 day

5.0

(9 reviews)

4.8

@Haider5811

Hi, Lets Get Started With This right Now……This is pretty straightforward task……and I can do this as u want….. I have done many projects similar to this…all with 5* feedbacks, hope will get a chance to work with u too. Message me to discuss and finish it asap…….thanks

$20 USD in 1 day

5.0

(22 reviews)

4.7

@konanhenry1111

I read details after u edit the project again I am expert and I can start now Just go to my profile and check my reviews from other clients .......................... .......................... .......................... ..........................

$20 USD in 7 days

5.0

(15 reviews)

3.5

@sana1aa

hi, i am data entry specialist I have more than five years of data entry, internet research, typing, pdf conversion work experience. My typing speed is 62 WPM. As data entry requires time and dedication, I see many provide faster services but fail to maintain error-free results. I always try to put my dedicated efforts to provide quick, clean, and error-free jobs to my clients. What will you get? Guaranteed Data Quality Complete Data Security 100% Accuracy On-Time Delivery I am at your Service. So feel free to place an order now.

$10 USD in 1 day

5.0

(2 reviews)

0.6

@soccon107

Hi! I have read your description and seen your attached word file, contact me and I can do it now. I have skills in Excel and have worked with Excel a lot in addition, I am also agile and very hard-working, dedicated to my work. Please contact me via chat to get the most effective work

$20 USD in 1 day

4.7

(3 reviews)

0.7

@Benita2002

Hello employer! I read your request and if what you need is a professional in Data entry( Visual Basics, WebSearch, PHP, Excel, Data Processing), Editing, Translation, Copytyping, and Web Search. I am 100% competent to get the job done, as a result of my experience of over 5 years in content writing, article writing, data entry, business writing, financial reporting, and creative writing as well as essay. I can finish up projects at your specified duration. Kindly inbox me if you would love to see some of my previous works. I look forward to assisting you to get the job done. Thank you.

$20 USD in 1 day

0.0

(0 reviews)

0.0

@NABILAHSAKINAH9

Hi! Hope you doing well My name is Nabilah, I am interested with this job. I am very hardworking person and can work effectively. Excellent in Microsoft words, excel and PowerPoint. Looking forward to your response and doing jobs with you. Thanks & Best Regards, Nabilah

$20 USD in 7 days

0.0

(0 reviews)

0.0

@krrishna26

My name is Kishor Thapa and I have been doing Data Entry work since 4 years, beside I also have good typing speed of 40 to 50 word per minutes.

$20 USD in 7 days

0.0

(0 reviews)

0.0

@smshaikh9535

My typing speed is good also I have a good technical knowledge so I can write the data of project in correct and sufficient manner.

$20 USD in 7 days

0.0

(0 reviews)

0.0

@DhavalKhandhar

I can do your work as soon as possible because i have worked like 1 year in ms word and excel besides i have done B.E in computer engineering

$20 USD in 1 day

0.0

(0 reviews)

0.0

@arosebajwa64

Hello Sir, I am an expert in excel, I saw the details and I understood well how to execute this task within the mentioned timeline. Looking forward to working with you. Thanks.

$10 USD in 1 day

0.0

(0 reviews)

1.0

@anneregine

As a persevering, hardworking person and computer literate, I’m experienced in basic transcriptions, presentation making, Basic Data entry from my previous On the Job Training company, and schedule management. I am also skilled in using Google Docs, Excel, PowerPoint, and Canva, basic photo editing, a video compilation, and editing. To further assure you of my qualifications, I have included my accomplishments in my resume enclosed with this paper. Also, I’m committed to my work and the assigned task that is being assigned to me. I am eager to utilize my abilities and experience as an effective Virtual Assistant I am looking forward to personally meeting with you to discuss how I can best apply my background and skills in this new role.

$20 USD in 7 days

0.0

(0 reviews)

0.0

@areebaaslam243

Hello, I can assist you with this project related to Research Article ,excel work. I am experienced in Article Writing, Research, Article Rewriting, Technical Writing and Research Writing. I have completed many similar assignments before. . I have completed many similar projects before. Please contact me for further discussion. I believe in providing the best quality work that will satisfy the client's specifications. I ensure 100% free plagiarism work. Lets connect and hire me today for your project. Please leave me a message for further discussion

$15 USD in 1 day

0.0

(0 reviews)

0.0

@kha2003aman

I am good at all Microsoft application . And I am very excited to do work with M.S. application And make you happy by my extraordinary work. Thank you Aman Khan

$15 USD in 7 days