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.