Käynnissä

Consolidate similiar data in spreadsheet, opens in excel

Consolidate Data with the same PRODUCT ID.

Perform a sum of the QTY Column for those Products ID that are the same.

The SKU Column is not required to be present in the new file nor is the ITEM/NAME Column.

Essentially all I need is a file with the ITEM/NAME the PRODUCT ID and a NEW Total QTY

The File has roughly 65k Rows of data.

Current Format of File.

ITEM/NAME \ SKU \ QTY \ PRODUCT ID

--------------------------------------\---------------------------\---------------\----------------------------

Row22 201 Organic Baby Purees 01-050305 8 1440528993

Row28 201 Organic Baby Purees 01-050305 2 1440528993

Row56 201 Organic Baby Purees SKU050305 7 1440528993

Needed Format Example.

ITEM/NAME \ SKU \ QTY \ PRODUCT ID

--------------------------------------\---------------------------\---------------\----------------------------

Row1 201 Organic Baby Purees Not Needed 17 1440528993

Taidot: tiedonsyöttö, tietojenkäsittely, Excel

Näytä lisää: new baby name, data in, consolidate, data consolidate, data sku, excel consolidate, qty file, consolidate excel, consolidate data excel, excel sku, excel sku spreadsheet, sku data entry, product spreadsheet, total baby, data entry sku, sku excel, spreadsheet column, consolidate data, spreadsheet products, qty file, Data spreadsheet, baby data excel, excel sum product, baby name excel, sum data data excel

Tietoa työnantajasta:
( 2 arvostelua ) Nicholasville, United States

Projektin tunnus: #4301060

Myönnetty käyttäjälle:

shatulina

Hi, I can do this in max 3hrs with accuracy and professionalism. Please check PM. Thanks and regards, Laura

66 $ USD 1 päivässä
(4 arvostelua)
2.5

15 freelanceria on tarjonnut keskimäärin 116 $ tähän työhön

dataworker2009

Hello, Pls have a look to your PM for the details regarding your project. Thanks

650 $ USD 15 päivässä
(232 arvostelua)
7.0
Innovative116

Hi. I am interested in the project. Please check private message for more details. Thank you

149 $ USD 3 päivässä
(71 arvostelua)
6.8
dablu11

Understand your requirement. Please check PM for details.

130 $ USD 10 päivässä
(23 arvostelua)
4.8
ethicalboy

Hi, this seems easy project.

30 $ USD 2 päivässä
(28 arvostelua)
4.7
LUretsky

I am a career accountant with 15 years of excel experience.

200 $ USD 2 päivässä
(13 arvostelua)
4.6
MDKAMRUL

I have all I need to work and can help you as you want. Just let me do. Thanks.

111 $ USD 10 päivässä
(36 arvostelua)
4.4
workerkmvw

Good day, I am interested in your project. Please read your messages for details.

60 $ USD 2 päivässä
(6 arvostelua)
3.7
shabukumar

Fair easy Job for me. So quoted accordingly. will come up with sample excel file (with the data provided in description) the way you require. 5 minutes from the time I placed my bid Please. Then we can discuss further Lisää

110 $ USD 7 päivässä
(12 arvostelua)
3.5
rohitpithisaria

Hi I am an excel expert and would like to apply for the job posted by you. Rgds Rohit

30 $ USD 2 päivässä
(5 arvostelua)
3.3
seaanddream

Hi, excel macro expert here... KR,

49 $ USD 1 päivässä
(5 arvostelua)
2.8
mfumia

Greetings, I have many years of Visual Basic (including VBA macros) development experience. I am available to begin work on your project immediately. Thank you for considering my bid, Matt

50 $ USD 1 päivässä
(2 arvostelua)
2.7
FLinCanada

Can do. But please clarify the Item/Name not needed wording. It looks like you want this column in the output.

30 $ USD 1 päivässä
(7 arvostelua)
2.5
bubu77

Hi, Excel expert having 8+ years of IT experience. I can do it for you. Please see your PM for more details.

45 $ USD 3 päivässä
(1 arvostelu)
2.0
danielbarragan13

I've got the skills needed to complete your project ASAP. PM for details

30 $ USD 0 päivässä
(0 arvostelua)
0.0