Complex Excel Data Transformation
$30-250 CAD
Paid on delivery
I have some Excel data that I need converted from columns to lines.
12000 lines Excel file with up to 14 components and quantity. The fibished file will have approx 60000 lines with only 1 component and quantity. Columns with 0 as a component should ne generate a line in the target file.
The data needs to be in the same Excel format after the initial conversion. This is for an import/export process, so maintaining the Excel structure is essential.
20240610BOM is the source file.
20240610BOMtest is an example of the target file from 2 lines of the of the source file.
Project ID: #38209002
About the project
Awarded to:
85 freelancers are bidding on average $112 for this job
Hello there, I am experienced in web scraping and building scripts or a Windows desktop application using python. I am also experienced in large data scraping from a given website, bypassing IP, Captcha, and anti-bot More
Hi there, I am ready to convert your Excel data from columns to lines, ensuring each component and its quantity are accurately transposed. The final file will maintain the Excel format required for your import/export More
Hi I can transopose data in required format, for eg Bom stock no Comp 1 Unit 1 colmsn into row format as shown in example file, I will use pandas moudle in python to complete task
"""""""""""""""""""COMPLEX EXCEL DATA TRANSFORMATION/EXCEL FORMATTING/ADVANCE EXCEL EXPERT"""""""""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, More
Hi there! I have expertise in this domain. Client's satisfaction is my first priority and believe in long-term relationship with clients. Please communicate to discuss in details. Thank you..
I am ready to assist you with converting your Excel data from columns to lines. Specifically, I will transform the 12,000 lines with up to 14 components and quantities into approximately 60,000 lines, ensuring each lin More
Hello. I am an experienced Excel expert and can help convert your 12,000-line Excel file from columns to lines. The final file will have approximately 60,000 lines, each with one component and quantity. I will ensure t More
ALREADY CHECKED TEST,,, i can automate this transformation process,,,,,,,, About me I am a CERTIFIED Excel VBA Programming , ADVANCE EXCEL , more 7 years experience ,,,,,,,
Having spent the past three years honing my skills in data processing, one of my core competencies is Excel mastery. I am particularly adept at complex data transformations, which makes me a perfect fit for your projec More
I am going to start your project right now. I will convert your Excel data from columns to lines, maintaining the same format. The source file (20240610BOM) will be transformed into the target file (20240610BOMtest) st More
Hi there, I checked your requirements and guarantee you that i have relevant experience in Excel it's gonna be done within the highest quality . Let's contact via chat so that I can start work immediately
"""""""""""""TOP EXCEL EXPERT"""""""""""""" Greetings! I clearly understand what is requirement of the project "" Complex EXCEL DATA TRANSFORMATION "". I am an EXCEL Advanced Level Expert. I have extensive experience More
Greetings, I'm ready to start the job. I’m willing to provide you with a FREE SAMPLE in this way you will be able to trust my quality work. My bid amount is negotiable and we can discuss it over chat. Are you looking More
Hello Eric L.! I have read your instructions keenly, and this is something I can comfortably do. I have advanced experience in Data Processing, Excel and Data Entry. I am excited to use my skills to help achieve y More