Pivot table from csv data saved as excel workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-1989806%22%20slang%3D%22en-US%22%3EPivot%20table%20from%20csv%20data%20saved%20as%20excel%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1989806%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20downloaded%20the%20data%20as%20csv%20from%20a%20financial%20institution%20website%20and%20saved%20the%20file%20as%20an%20Excel%20workbook.%20But%20when%20I%20try%20to%20create%20the%20pivot%20table%2C%20it%20says%20that%20I%20have%20empty%20cells%20and%20won't%20create%20the%20table.%20I%20am%20not%20seeing%20any%20empty%20cells%20in%20the%20range%20that%20I%20have%20selected.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1989806%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1990740%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20from%20csv%20data%20saved%20as%20excel%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1990740%22%20slang%3D%22en-US%22%3EWhenever%20you%20select%20the%20data%20for%20pivot%20just%20verify%20whether%20the%20first%20row%20has%20data%20in%20all%20cells%20or%20not%3CBR%20%2F%3E%3CBR%20%2F%3EThen%20you%20will%20not%20get%20that%20error%3C%2FLINGO-BODY%3E
Occasional Visitor

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.

 

2 Replies
Whenever you select the data for pivot just verify whether the first row has data in all cells or not

Then you will not get that error

@Karen2310 

You converted only one column in the range to the table, not sure what was the reason

image.png

If convert this column back to range and create the table from all columns, or use the range only, you may create PivotTable

image.png