CharlesWhiteman
Registered User.
- Local time
- Today, 20:53
- Joined
- Feb 26, 2007
- Messages
- 421
I have a spreadsheet which will form the basis of a csv file to import circa 50,000 documents into a system. The import file will contain meta dataand a reference to a logical path to the document (to be imported).
The problem I have is that many of the lines have more pages and the path to the page is tagged onto the end of the line not as a new line.
So if I solve it manually then I would create a new row. Copy and paste the data from the line above and then cut and paste the path reference into the correct column.
I am trying to find a way to automate this as there are 10,000's of lines affected.
I have attached a sample where the following note applies:
Row 2 is an affected line because there is a valuein column W. So in column 5 I would copy the data from columns A-u into row 5 and then cell W4 would be copied to W5 to make a complete line
Any advice gratefully received
The problem I have is that many of the lines have more pages and the path to the page is tagged onto the end of the line not as a new line.
So if I solve it manually then I would create a new row. Copy and paste the data from the line above and then cut and paste the path reference into the correct column.
I am trying to find a way to automate this as there are 10,000's of lines affected.
I have attached a sample where the following note applies:
Row 2 is an affected line because there is a valuein column W. So in column 5 I would copy the data from columns A-u into row 5 and then cell W4 would be copied to W5 to make a complete line
Any advice gratefully received
