You can't. You'll hit limits that prevent this long before you get anywhere near 500 columns. You'd need to use multiple layouts--each displaying a subset of the total number of columns.
500 columns means 500 fields and that seems a very extreme number of columns. It's very likely that a different approach using one or more related tables would be a better option for doing this in a database system such as FileMaker.