Dears,
I'll try to be as short & detailed as possible - Trying to achieve the subject.
Example Excel Source file:
| Document ID | Document Name | Document
Approval Date | Product Name |
| 1 | X | 01/01/2021 | Product A |
| 2 | Y | 01/01/2021 | Product B |
| 3 | Z | 01/01/2021 | Product A, Product B, Product C |
Based on the above input, I would like to generate this type of List on Sharepoint:
| Sharepoint ID | Document ID | Document Name | Document
Approval Date | Product Name |
| 1 | 1 | X | 01/01/2021 | Product A |
| 2 | 2 | Y | 01/01/2021 | Product B |
| 3 | 3 | Z | 01/01/2021 | Product A |
| 4 | 3 | Z | 01/01/2021 | Product B |
| 5 | 3 | Z | 01/01/2021 | Product C |
Note: This is a daily report & activity, I will need to be able to update in Sharepoint an already existing document information if anything changes.
Note 2: Basically, and in words, what I need help here with is:
Creating X Sharepoint entries based on the X number of products I have in the Product name column in Excel.
