Excel split last element
€8-30 EUR
Thanh toán khi bàn giao
Hello, I need two excels from 1. The excel is all the categories, I need the last element cut off and put into another excel. Examples:
1. Antiques > Antiquities > Roman
-> excel 1: Antiques > Antiquities
-> excel 2: Roman
2. Business & Industrial > Automation, Motors & Drives > Control Systems & PLCs > PLC Peripheral Modules > PLC Positioning Modules
-> excel 1: Business & Industrial > Automation, Motors & Drives > Control Systems & PLCs > PLC Peripheral Modules
-> excel 2: PLC Positioning Modules
3. Travel > Luggage
-> excel 1: Travel
-> excel 2: Luggage
The excel has 17000 records so you need to be able to automate this.
In the first excel you need to keep the original '>' separator.
I need unique records (duplicates removed) in both excels.
ID dự án: #28328335
Về dự án
Được trao cho:
HI I am an expert in Excel and VBA application. I can help you with this task fast and accurate. Contact me to discuss. Regards!
20 freelancer chào giá trung bình€20 cho công việc này
Excel expert at your service. Please check my past reviews for your reference. Looking forward for your reply so that I can start with the implementation.
Hi, I can split text to columns using Excel formula. I can send a file immediately. Let’s discuss if you’re interested. Best regards, Duong
Hi, I can split the last element and create 2 separate sheets as per your requirement. I am an Excel expert and ready to complete this project in 2 hours. Regards Soni
Hi, Checked your attachment excel & am ready to start right now. If you are interested to message me we can discuss more. Thanks, Ashik
Greetings Thanks for checking my proposal. I have understood your project and can start your project immediately. I am now full- time freelancer after job experience of more than two decades. It included more than deca Thêm
SUPER EASY. Available and ready to start immediately. Hope to complete in just few minutes. Best Regards Imran
Hi there! I have expertise in excel VBA. I can do it right now. Client's satisfaction is my first priority and believe in long-term relationship with clients. Please communicate to discuss in details. Thank you..
Hi... I understand ur requirement...... I can split ur excel Pls open chat..... If you want I can do a sample of the work.... I can deliver the project with 100% accuracy and on time. If you want to know about me pl Thêm
Hi! I can write formula to give you the desired result. I can complete this project within 2-3 hours if assigned. Let me know if you are interested. Regards!
Hello, I've read all the details about this job and I think I can complete this job since I've experienced a lot in using excel. Kindly contact me so that we can discuss about this job further. Best regards, Nur Dyan Thêm
I believe that I am the best candidate for this job because I have a lot of experience in data analysis and work with data in Excel and other Microsoft Office's tools on daily basis due to my occupation. That is why Thêm
Hi sir/madam, I understood the requirements and I can help you splitting the data. I am very proficient in Excel with 2 years experience working and handling big volume of data in Excel. I work hard and work smart and Thêm
Hi, dear buyer, I hope you will be fine .i have ready carefully about your project. i am skilled in data entry .even if I’m new here ,i can assure you that I’m very motivated and make sure task given to me are Complet Thêm