VBA Script to convert an Excel Table or Range to an xml file VBA script to export either an Excel Table or an Excel Range to an xml file How it works: the script loops the row count of the set data ...

Excel has a button inside Table Design called Convert to Range, which essentially removes the 'table' but leaves the data untouched (so long as there are no references).

The new capability released include use of Artificial Intelligence in the Excel that lets you convert a photo table into an Excel spread sheet.

Open Excel and add a new column to the left of the data range you want to convert to a single column.