Complex Excel Data Transformation

Completed Posted 7 months ago Paid on delivery
Completed 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.

Excel Data Processing Data Entry

Project ID: #38209002

About the project

85 proposals Remote project Active 7 mos ago

Awarded to:

(138 Reviews)
6.2

85 freelancers are bidding on average $112 for this job

livegoodlife

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

$100 CAD in 2 days
(375 Reviews)
8.1
mirniyazuddin92

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

$150 CAD in 3 days
(483 Reviews)
8.2
saqibmunir55

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

$100 CAD in 1 day
(871 Reviews)
8.0
AccountantArman

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

$99 CAD in 1 day
(314 Reviews)
7.5
sy3d

output file should be like this? C2E5070171S B000300 100 C2E5070171S B992310 0.623 C2E5070171S B999953 0.798 C2E5070171S B999075 1.067 C2E5070171S B999030 4.512 C2E5070171S B506168 1.108 am i right? yes we can do this More

$90 CAD in 2 days
(364 Reviews)
7.4
oadsmedia

Hello Eric , Good day I have read your project requirements. I've worked on similar projects with excellent results. 10 years of professionalism and experience are specified. So that I have a straightforward way to c More

$50 CAD in 1 day
(102 Reviews)
7.0
axiomswb

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

$100 CAD in 2 days
(54 Reviews)
7.0
sknadeem123

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

$99 CAD in 1 day
(115 Reviews)
6.6
Hadiibaba

Dear Client, We propose to convert your 12000-line Excel file, containing up to 14 components and quantities per line, into a format with approximately 60000 lines, where each line will represent only one component an More

$140 CAD in 7 days
(80 Reviews)
6.3
CloudNineDigital

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

$250 CAD in 10 days
(104 Reviews)
6.4
sareheshak

ALREADY CHECKED TEST,,, i can automate this transformation process,,,,,,,, About me I am a CERTIFIED Excel VBA Programming , ADVANCE EXCEL , more 7 years experience ,,,,,,,

$80 CAD in 1 day
(63 Reviews)
5.7
Azfarzul

Hello, As an experienced data entry specialist and proficient Excel user, I can expertly handle your complex data transformation project. With over [insert number of years] in the field, I’ve come to understand the imp More

$165 CAD in 2 days
(43 Reviews)
5.3
chwaqas5434

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

$50 CAD in 1 day
(64 Reviews)
5.6
OmarFarukBD

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

$150 CAD in 5 days
(16 Reviews)
5.1
MMURajo10

Hello there, I have gone through your project description, I have fully understood I am assuring you I can help you on your project please help me. If you give me less payment I am agree to work. Upon checking my pr More

$140 CAD in 7 days
(15 Reviews)
5.0
ashrafsbai6655

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

$200 CAD in 1 day
(7 Reviews)
4.9
ACCASpogmai

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

$55 CAD in 1 day
(38 Reviews)
4.9
FardinkhanBoss

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

$150 CAD in 3 days
(19 Reviews)
5.0
wairimubredah20

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

$154 CAD in 2 days
(3 Reviews)
3.9
Sunitav36

Hi, I am a certified data analyst and have 13+ years of experience. I'll provide you quality work according to your instructions. Please award me the project so that we can discuss it more. Below are the my services More

$140 CAD in 4 days
(24 Reviews)
3.9