If your data includes inconsistent types, such as numbers mixed with text in the same column, this automatic step can cause ‘DataFormat.Error: We couldn’t convert to Number’. After deleting ...

You can first convert this record from column to row, and then concatenate every two records ... and the grouping subsets can be retained without aggregation. # is the row number, \ is division to ...

For instance, currency columns may be formatted so that numbers always have ... like setting alternating colors and converting column headers so you can sort and filter by the data beneath them.