Dec 15 2020 09:23 AM
I have downloaded the data as csv from a financial institution website and saved the file as an Excel workbook. But when I try to create the pivot table, it says that I have empty cells and won't create the table. I am not seeing any empty cells in the range that I have selected.
Dec 15 2020 11:48 AM
Dec 15 2020 01:49 PM
You converted only one column in the range to the table, not sure what was the reason
If convert this column back to range and create the table from all columns, or use the range only, you may create PivotTable