Hi,
I've regular data that is in csv format and always more than 1 million row. I normally upload the data to access, then correct the data ( as some rows have repeated column headings) and run query the data and copy-paste to different excel files.

Is there any other cleaner way as it takes a lot of time and shows the limitation of excel bluntly.

regards
Satti, Charvak