Đã hoàn thành

Excel split last element

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.

Kĩ năng: Xử lí dữ liệu, VBScript

Xem nhiều hơn: excel split file vba, excel split file keep header download experts exchange, excel split cell string, vba excel split string cells, excel split data separate sheets xlsm, excel split rows separate sheets, excel spreadsheet element, search string excel split cell macro, excel split separate sheets, excel split cell, excel split, excel split sheet, excel split sheet sheets, excel split data sheets, excel split a cell, excel split cell into 2, excel split columns, excel split string, how to combine two excel sheets into one without duplicates, excel split url into columns

Về Bên Thuê:
( 14 nhận xét ) Brussels, Belgium

ID dự án: #28328335

Được trao cho:

Barroga17

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!

€8 EUR trong 1 ngày
(14 Đánh Giá)
3.7

22 freelancer chào giá trung bình€19 cho công việc này

(158 Nhận xét)
7.6
Teloquence

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.

€19 EUR trong 7 ngày
(116 Nhận xét)
6.8
(87 Nhận xét)
6.4
hdlan

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

€15 EUR trong 1 ngày
(41 Nhận xét)
6.4
best4best

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

€19 EUR trong 1 ngày
(83 Nhận xét)
6.0
(99 Nhận xét)
6.1
(99 Nhận xét)
5.5
Imranatmoon

SUPER EASY. Available and ready to start immediately. Hope to complete in just few minutes. Best Regards Imran

€20 EUR trong 1 ngày
(34 Nhận xét)
4.6
axiomswb

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

€15 EUR trong 1 ngày
(7 Nhận xét)
4.1
Akib2020

✅ Expert on Advanced Excel ✅ Hi there! I’m expert on Advanced Excel, VBA, Macro, Combine multiple excel sheet, categories data, split data, text to column, Vlookup, hloolup, match, index, array, nested if, Complex Form Thêm

€30 EUR trong 1 ngày
(18 Nhận xét)
3.4
professional800

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

€9 EUR trong 1 ngày
(12 Nhận xét)
3.3
Boopathy808

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

€30 EUR trong 1 ngày
(3 Nhận xét)
2.4
gulzarhussain

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!

€20 EUR trong 1 ngày
(4 Nhận xét)
2.1
Ashikuzzaman7

Hi, Checked your attachment excel & am ready to start right now. If you are interested to message me we can discuss more. Thanks, Ashik

€14 EUR trong 1 ngày
(14 Nhận xét)
2.4
krishraghav29

OUTPUT READY OUTPUT READY OUTPUT READY OUTPUT READY OUTPUT READY OUTPUT READY OUTPUT READY OUTPUT READY OUTPUT READY OUTPUT READY

€10 EUR trong 1 ngày
(1 Nhận xét)
0.5
dyanaambiah

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

€20 EUR trong 3 ngày
(0 Nhận xét)
0.0
zhannapaulenka

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

€25 EUR trong 2 ngày
(0 Nhận xét)
0.0
DinTechSolutions

Hello Sir, Gone through your project and understood it well. It's a simple Excel Project and can be done in very short time. I am Asstt. Manager in an International reputed BPO, Genpact. My 90 % work is on Excel and Thêm

€10 EUR trong 1 ngày
(0 Nhận xét)
0.0
khalid415

Hello, I am interested in the job offer, you can explain what it is and what I should do specifically, I am at your service and I have availability, I can take some time to transcribe quickly and without mistake. I can Thêm

€24 EUR trong 3 ngày
(0 Nhận xét)
0.0
hanifzulkifli

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

€15 EUR trong 4 ngày
(0 Nhận xét)
0.0