Excel split last element

Đã hoàn thành Đã đăng vào 3 năm trước Thanh toán khi bàn giao
Đã hoàn thành 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.

Xử lí dữ liệu VBScript

ID dự án: #28328335

Về dự án

20 đề xuất Dự án từ xa 3 năm trước đang mở

Đượ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
(17 Đánh Giá)
4.3

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

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.9
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
(48 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
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
(39 Nhận xét)
5.5
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
(24 Nhận xét)
4.6
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
(47 Nhận xét)
4.6
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
(38 Nhận xét)
4.7
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
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.5
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
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
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
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
ahadanwar786

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

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