Hi everyone, I am new here as a member and hope you will be able to help.
I am trying to upload some data in a CSV to an online system which requires that each record is on a different line, but the data I have been given is all on one line, let me try to explain.
This is the data I have:
<tbody>
</tbody>
And this is how I wish it to look:
<tbody>
</tbody>
Couple of points, I don't need all the other fields, just the Prod ID, ImgSrc and an incrementing number for each image associated with a Prod ID. Also some of the images may be used more than once, they are not unique.
I hope someone can help, I have been wrestling with this for a little while and as there are over 500 records, more later, I don't want to do this manually.
Best regards
Jonathan
I am trying to upload some data in a CSV to an online system which requires that each record is on a different line, but the data I have been given is all on one line, let me try to explain.
This is the data I have:
Prod ID | Prod Desc | ImgSrc1 | ImgSrc2 | ImgSrc3 |
1234 | Useful Product | 12.jpg | 13.jpg | 14.jpg |
5678 | Less Useful Item | 15.jpg | 16.jpg |
<tbody>
</tbody>
And this is how I wish it to look:
Prod ID | Prod Desc | ImgSrc | ImgNumber |
1234 | 12.jpg | 1 | |
1234 | 13.jpg | 2 | |
1234 | 14.jpg | 3 | |
5678 | 15.jpg | 1 | |
5678 | 16.jpg | 2 |
<tbody>
</tbody>
Couple of points, I don't need all the other fields, just the Prod ID, ImgSrc and an incrementing number for each image associated with a Prod ID. Also some of the images may be used more than once, they are not unique.
I hope someone can help, I have been wrestling with this for a little while and as there are over 500 records, more later, I don't want to do this manually.
Best regards
Jonathan