I tried creating a Pivot Table, but couldn't figure it out.
I tried selecting a range that include the column headings, and without the headings row, but I still get this error...
"The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns."

My spreadsheet goes from A to V columns, name is in A and amount column is V, the last one. There are some empty columns in between, but I need them there.

Is there anything else I can try?