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

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

Evner: Excel

Om klienten:
( 15 bedømmelser ) Santos, Brazil

Projekt ID: #32673420

Tildelt til:


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 på 1 dag
(1 bedømmelse)

33 freelancere byder i gennemsnit $20 timen for dette job


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 developi Flere

$20 USD på 1 dag
(218 bedømmelser)

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 på 1 dag
(405 bedømmelser)
(164 bedømmelser)
(155 bedømmelser)

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

$20 USD på 1 dag
(69 bedømmelser)

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 Flere

$30 USD på 1 dag
(15 bedømmelser)

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 sat Flere

$21 USD på 1 dag
(47 bedømmelser)

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 exp Flere

$30 USD på 1 dag
(9 bedømmelser)

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

$20 USD på 1 dag
(22 bedømmelser)
(16 bedømmelser)

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

$20 USD in 7 dage
(15 bedømmelser)
(11 bedømmelser)

Hello, I have understood your project requirement of data manipulation in excel. I am confident to complete it with 100% accuracy. I am a new freelancer however I have 16 years of Industry experience as a Business Ana Flere

$16 USD in 7 dage
(1 bedømmelse)

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 pro Flere

$10 USD på 1 dag
(2 bedømmelser)

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 t Flere

$20 USD på 1 dag
(3 bedømmelser)

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 t Flere

$20 USD på 1 dag
(0 bedømmelser)

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 Flere

$20 USD in 7 dage
(0 bedømmelser)

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 dage
(0 bedømmelser)

"Hi, I am expert in Advance excel and Formulas building I can create complex logics using Formulas I am also capable off creating any macros using VBA I have developed many macros for Project in Company I as a single Flere

$15 USD in 7 dage
(0 bedømmelser)

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 dage
(0 bedømmelser)