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.
Được trao cho:
22 freelancer chào giá trung bình€19 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 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 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 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!