Complex Excel Data Transformation

Suoritettu Julkaistu 7 kuukautta sitten Maksettu toimituksen yhteydessä
Suoritettu Maksettu toimituksen yhteydessä

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 Tietojenkäsittely Tiedonsyöttö

Projektin tunnus: #38209002

Tietoa projektista

85 ehdotusta Etäprojekti Aktiivinen 7 kuukautta sitten

Myönnetty käyttäjälle:

(138 Arvostelua)
6.2

85 freelanceria on tarjonnut keskimäärin $112 tähän työhön

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 Lisää

$100 CAD 2 päivässä
(375 arvostelua)
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 Lisää

$150 CAD 3 päivässä
(483 arvostelua)
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 1 päivässä
(871 arvostelua)
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, Lisää

$99 CAD 1 päivässä
(314 arvostelua)
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 Lisää

$90 CAD 2 päivässä
(364 arvostelua)
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 Lisää

$50 CAD 1 päivässä
(102 arvostelua)
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 2 päivässä
(54 arvostelua)
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 Lisää

$99 CAD 1 päivässä
(115 arvostelua)
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 Lisää

$140 CAD 7 päivässä
(80 arvostelua)
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 Lisää

$250 CAD 10 päivässä
(104 arvostelua)
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 1 päivässä
(63 arvostelua)
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 Lisää

$165 CAD 2 päivässä
(43 arvostelua)
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 Lisää

$50 CAD 1 päivässä
(64 arvostelua)
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 Lisää

$150 CAD 5 päivässä
(16 arvostelua)
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 Lisää

$140 CAD 7 päivässä
(15 arvostelua)
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 1 päivässä
(7 arvostelua)
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 Lisää

$55 CAD 1 päivässä
(38 arvostelua)
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 Lisää

$150 CAD 3 päivässä
(19 arvostelua)
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 Lisää

$154 CAD 2 päivässä
(3 arvostelua)
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 Lisää

$140 CAD 4 päivässä
(24 arvostelua)
3.9