Hello,

We currently have automatically generated CSV reports, however due to system restrictions the data we require is across multiple repeated columns (DateA, TimeA, DateB, TimeB etc etc).

Ideally I would like to combine these columns in to one to make it easier to read for the end user.

Since the reports are system generated I assume this will have to be done by an external file that simply references the new files every day. I assume this is possible as there are constants in the reports generated, such as column names and Cells etc.

One stumbling block (quite a major one) is that I simply don't know how to accomplish this. Searching around I assume it will have to be with a macro, however I have no idea how to write VB, but I do have experience with coding websites if that helps.

I by no means expect someone to write the entire thing for me, but if someone could just get me started with a bit of code where I can clearly see cell references in order to change and add more, that would be ideal.

Any help would be greatly appreciated.

Thanks in advance.