Your question is very generic, im am not sure what exactly you are looking for.
Did you check out the learning paths on the basics of Mendix? They are very good in giving an impression of what Mendix can do and how to approach creating an app.
For example: https://academy.mendix.com/link/path/83/Build-an-App-in-Mendix-Studio
In general, you can create an entity with attributes, which would be translated by Mendix into a database table containing a column for every attribute.
However: Mendix is not Excel, in so many ways.
I hope this helps.
What is the scope of the size of the table? Does everything HAVE to be presented in a table like way with all of the columns on one page?
Are using widgets to break up/make that data show in different ways out of the question?
you have 2 options:
- horizontal scroll (this is really not recommended from the UX)
- use datatables widgets and extend to hide / show columns according to your user choice, this will be a big efford.
those are the options you have.