Transform excel list (specific data to be repeated on left side)
Budget $10-30 USD
**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.
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.
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
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!!
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
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
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
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
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
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
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
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
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.
"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
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.
