Thank you Oleg.

By the way, with regard to my additional query "Is it possible to do a direct export of a table to Excel with columns and rows being the same?"

I am using AutoCAD 2009 and I found an in built "tableexport" command that exports a table to a .csv file.
I didn't know it existed.
With AutoCAD I learn something new every day.

Have a good holiday.

Best Regards.