I have several lines of data and there are several entries that need to be cleaned.
Here is an example of "good" data:
15927 | 8/12/2021 | 11:56:50 | 65565251 | 65565250 | 65565249 | 65565248 | 65565262 | 161.7 | 161.6 | 161 | 161.8 | 160.5 | 159.6 | 161.5 | 160.5 | 160.6 | 159.3 | 165.3 | 164.7 | 20.73 |
and here is what shows up on several lines:
15937 | 8/12/2021 | 11:59:24 | 65565261 | 65565260 | 65565259 | 5258 | ||||||||||||||
65565257 | 161 | 160.6 | 160.3 | 161 | 159.7 | 158.5 | 160.3 | 159.7 | 159.8 | 158.3 | 165.5 | 164.9 | 21.35 |
The data gets split for some reason into 2 lines. In the case above it got split on column 7, but sometimes that split will show up on column 3, 4, or 5, for example. I need to clean up this data and it extends of 10,000+ lines in excel.
As a bonus (I'm not sure how well macros can work) is that the data that is corrupted, you can see that the barcode 5258 was not read correctly by our barcode reader. It should have been 65565258. In essence, the barcode reader missed the first 4 digits (which tend to be the same from day to day). But the problem with this one is that is sometimes misses the first 4 numbers and sometimes it only misses the first 2 numbers.
I am hoping for a quick macro that can help me.
Thank you in advance!!!!