Forum Discussion
Sorting data - by reference
Hi I have data set like this; Date Reference 28/11/2017 119737 28/01/2018 119737 28/02/2018 119737 28/03/2018 119737 07/09/2017 119787 07/10/2017 119787 07/11/...
Hi,
If i've this problem, I will go for "Remove duplicates" function to removing duplicates.
Then i do macro for filtering and export as CSV.
On which basis you separating CSV? on date basis or reference basis?
Unfortunately all the dates are different so I need all the lines to import into the database.
I just need to split the data so there's only one line for each reference on each page.
To do it for the first lot of data I sorted references and then went down numbering them 1,2,3 etc and then moving all 1's onto a a new tab, all 2's onto a new tab etc.
Sadly my eyes let me down and there were a few references with several dates on one page.
Therefore the import failed.
Does that make sense?