Looking for very dynamic user driven web table/grid for MVC custom columns

Client is looking for the most dynamic user customisable table/grid (where we display numbers like invoice liens).

Each user should be able to move columns around, hide/show columns, filter, sort, maybe pivot grouping (also make coffee). And then save that configuration for next time they get to that grid. And there are a number of these grids in the system.

The table/grid also has edit cells, right-mouse-bottom events, move rows.

System is web MVC6 (ASP.Net c#) with razor tables setting. A number of JScipt/Ajax had to be added also.