Macro that can be applied to any workbook that needs same editing

Hi experts, I'm really stressed on how can i easily delete all unnecessary
columns & rows, and then combining the text in J , U and V column.

I want file #1..
to become file #2.

I already tried macro recording and saving the macro in my personal workbook but
when i run the same macro on other work book, its not working. Honestly, my knowledge in using
vba is very little so i really need your help.

Hi khr0n0s,

Using Power Query the new tool built into Excel, your problem took me about 2 minutes. PQ is called Get & Transform in 2016 Excel.

Here is the Query

Please Login or Register  to view this content.

But I didn't need to write any of the code above. Open the attached and then look at the Power Query and edit it. It is much easier than VBA code to do this stuff.

Power Query CSV1 to 2.xlsx

If you put the 1.csv on your desktop and change the source of the above code you can repro what I did. OR - Learn a bit more about Power Query.

If your CSV file always looks like what you gave, then yes.

You also need either Excel 2016 which has the "Get & Transform" tool or download it and use it as an Add-in called Power Query if you have Excel 2010 or 2013. I also believe you need to be using the PC (not Mac) version of Excel.

Search on Power Query and see some examples of PQ and how to use it.