Best practices to allow user to hide/show columns in a data table
I have a table which can contain more than 15 columns, it is not likely that users will see the 15 columns at the same time, but I need to give them the option to select which columns they want to see. I added a section in the table to allow the user to choose from the "Available columns" and move them to the "Selected columns" that will be displayed:
But the client didn't like it, because he is looking for something more interactive and intuitive. Can you recommend me other controls that I can use? Note! The table is like an excel table, user can expand, filter and sort by column. I was thinking of using something similar to excel to hide the columns, but I couldn't find out how to make the "show" columns.