Hello
I have an Excel file (Please find attached). But due to wrong formatting over thousands of values it builds up a big stack (endless) as it associates multiple different models and their information with that keyword.
When I use the VBA to export the columns into a .txt file, it targets column B, C, D. It should do the trick, however a keyword is messing everything up, stacking the information that should be associated with the car model. (please see example.txt) to understand what it currently does when exporting the data into the .txt as an output.
In principle, it just 'steals' the information from the associated car model, as there are multiple entries of this "New" keyword which get associated hence it builds up and 'steals' from other car models.
At first I thought of finding and replacing the "New" keyword with the actual car model, but as there are many variations with thousands of entries, I guess it's not that doable manually.
I was thinking of a VBA to repair the Excel formatting such as:
Not sure about how to fix this, or even if it is fixable, as there are hundreds if not thousands of variations of model with their information'stolen' by this keyword...
Any help would be greatly appreciated
Thanks!
Bookmarks