Generate CSV Excel list based on other CSV Excel list
- or -
Post a project like this1401
€30(approx. $32)
- Posted:
- Proposals: 5
- Remote
- #2871752
- PRE-FUNDED
- Awarded
Description
Experience Level: Entry
Hello,
i am looking forward to work with you.
General Information
- task need to be done within 8 hours
- we need support after the project if we have to change the list (3 hours support should be included in your offer)
Project Information
- we HAVE a list A with a variable number of Product IDs and EAN Numbers.
- we NEED a list B based on list A. For every Product ID from List a List B has 9 lines:
++++++++++++++++++++++++++++++Example++++++++++++++++++++++++++++++++++++++
****List A****
(ignore first row "Artikelnumber"
Artikelnummer EAN ID
0 RA2604 165753591
...
*****List B*****
-> row A= insert same Product ID 165753630 for all 9 lines, insert next Product ID for the next 9 lines etc.
-> row B = "Parent": always 0 for all lines
-> row C = "Nr":
value for the first 3 lines is 1
value for the next 3 lines is 2
value for the last 3 lines is 3
this is repeating for every Product ID
-> row D = "Typ" is counting from 0 to 2 for every value in row C
value for line 1 = 0
value for line 2 = 1
value for line 3 = 2
value for line 4 = 0
value for line 5 = 1
value for line 6 = 2
value for line 7 = 0
value for line 8 = 1
value for line 9 = 2
this is repeating for every Product ID
-> row E is "AltText": always 0 for all lines
-> row F is "URL" (URL Structure is always the same: https://penz-v.de/produkte/EAN/EAN (1).JPG)
first 3 lines = https://penz-v.de/produkte/RA2604/RA2604 (1).JPG
next 3 lines = https://penz-v.de/produkte/RA2604/RA2604 (2).JPG
last 3 lines = https://penz-v.de/produkte/RA2604/RA2604 (3).JPG
this is repeating for every Product ID
-> row G is "ID": always 0 for all lines
List B final
Poduct ID Parent Nr Typ Alt Url ID
165753630 0 1 0 0 https://penz-v.de/produkte/RA2604/RA2604 (1).JPG 0
165753630 0 1 1 0 https://penz-v.de/produkte/RA2604/RA2604 (1).JPG 0
165753630 0 1 2 0 https://penz-v.de/produkte/RA2604/RA2604 (1).JPG 0
165753630 0 2 0 0 https://penz-v.de/produkte/RA2604/RA2604 (2).JPG 0
165753630 0 2 1 0 https://penz-v.de/produkte/RA2604/RA2604 (2).JPG 0
165753630 0 2 2 0 https://penz-v.de/produkte/RA2604/RA2604 (2).JPG 0
165753630 0 3 0 0 https://penz-v.de/produkte/RA2604/RA2604 (3).JPG 0
165753630 0 3 1 0 https://penz-v.de/produkte/RA2604/RA2604 (3).JPG 0
165753630 0 3 2 0 https://penz-v.de/produkte/RA2604/RA2604 (3).JPG 0
Another example with more product IDs is attached.
There should be a button in list A to generate List B.
Best regards
Severin
i am looking forward to work with you.
General Information
- task need to be done within 8 hours
- we need support after the project if we have to change the list (3 hours support should be included in your offer)
Project Information
- we HAVE a list A with a variable number of Product IDs and EAN Numbers.
- we NEED a list B based on list A. For every Product ID from List a List B has 9 lines:
++++++++++++++++++++++++++++++Example++++++++++++++++++++++++++++++++++++++
****List A****
(ignore first row "Artikelnumber"
Artikelnummer EAN ID
0 RA2604 165753591
...
*****List B*****
-> row A= insert same Product ID 165753630 for all 9 lines, insert next Product ID for the next 9 lines etc.
-> row B = "Parent": always 0 for all lines
-> row C = "Nr":
value for the first 3 lines is 1
value for the next 3 lines is 2
value for the last 3 lines is 3
this is repeating for every Product ID
-> row D = "Typ" is counting from 0 to 2 for every value in row C
value for line 1 = 0
value for line 2 = 1
value for line 3 = 2
value for line 4 = 0
value for line 5 = 1
value for line 6 = 2
value for line 7 = 0
value for line 8 = 1
value for line 9 = 2
this is repeating for every Product ID
-> row E is "AltText": always 0 for all lines
-> row F is "URL" (URL Structure is always the same: https://penz-v.de/produkte/EAN/EAN (1).JPG)
first 3 lines = https://penz-v.de/produkte/RA2604/RA2604 (1).JPG
next 3 lines = https://penz-v.de/produkte/RA2604/RA2604 (2).JPG
last 3 lines = https://penz-v.de/produkte/RA2604/RA2604 (3).JPG
this is repeating for every Product ID
-> row G is "ID": always 0 for all lines
List B final
Poduct ID Parent Nr Typ Alt Url ID
165753630 0 1 0 0 https://penz-v.de/produkte/RA2604/RA2604 (1).JPG 0
165753630 0 1 1 0 https://penz-v.de/produkte/RA2604/RA2604 (1).JPG 0
165753630 0 1 2 0 https://penz-v.de/produkte/RA2604/RA2604 (1).JPG 0
165753630 0 2 0 0 https://penz-v.de/produkte/RA2604/RA2604 (2).JPG 0
165753630 0 2 1 0 https://penz-v.de/produkte/RA2604/RA2604 (2).JPG 0
165753630 0 2 2 0 https://penz-v.de/produkte/RA2604/RA2604 (2).JPG 0
165753630 0 3 0 0 https://penz-v.de/produkte/RA2604/RA2604 (3).JPG 0
165753630 0 3 1 0 https://penz-v.de/produkte/RA2604/RA2604 (3).JPG 0
165753630 0 3 2 0 https://penz-v.de/produkte/RA2604/RA2604 (3).JPG 0
Another example with more product IDs is attached.
There should be a button in list A to generate List B.
Best regards
Severin
Arndt A.
100% (13)Projects Completed
15
Freelancers worked with
14
Projects awarded
48%
Last project
21 Apr 2021
Germany
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies