Concluído

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.

Habilidades: Processamento de dados, VBScript

Veja mais: 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

Acerca do Empregador:
( 14 comentários ) Brussels, Belgium

ID do Projeto: #28328335

Concedido a:

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 em 1 dia
(14 Comentários)
3.7

22 freelancers estão ofertando em média €19 nesse trabalho

(158 Comentários)
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 in 7 dias
(116 Comentários)
6.8
(87 Comentários)
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 em 1 dia
(41 Comentários)
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 em 1 dia
(83 Comentários)
6.0
(99 Comentários)
6.1
(99 Comentários)
5.5
Imranatmoon

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

€20 EUR em 1 dia
(34 Comentários)
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 em 1 dia
(7 Comentários)
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 Mais

€30 EUR em 1 dia
(18 Comentários)
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 Mais

€9 EUR em 1 dia
(12 Comentários)
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 Mais

€30 EUR em 1 dia
(3 Comentários)
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 em 1 dia
(4 Comentários)
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 em 1 dia
(14 Comentários)
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 em 1 dia
(1 Comentário)
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 Mais

€20 EUR in 3 dias
(0 Comentários)
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 Mais

€25 EUR in 2 dias
(0 Comentários)
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 Mais

€10 EUR em 1 dia
(0 Comentários)
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 Mais

€24 EUR in 3 dias
(0 Comentários)
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 Mais

€15 EUR in 4 dias
(0 Comentários)
0.0