Professor Excel
data, table, data table, excel, convert, normal range

Data Table to Normal Range: How to Convert an Excel Table

Data Tables were introduced in Excel 2007. They were supposed to simplify the work with data in Excel. But in the reality they often made it more difficult. For example, handling different formulas in the same column is not really possible. Fortunately, you can easily convert a Data Table into a normal range.