Not sure if this is the correct site to ask this but I will anyways.
I'm an inexperienced web developer and my company is having me convert a simple Excel application into a web page format. The Excel sheet essentially is used as a part search tool. For some reason, for a while now they have gotten here by having IT add the most recent parts every so often to the Excel sheet. It includes about 30,000 records and about 40 different part attributes (40 columns). The only functions that can be done on this "application" is having the user enter a search term for any particular column, e.g. searching all records for customer XXX.
Although I have a general idea on how to set it up (maybe not the best way), I don't know how to best format it so that the user doesn't have to scroll sideways to look at all the fields because there is 40+. I guess my question is: What is the ideal way to format my web page so that the user can see 40+ fields in a table without having to scroll horizontally? Now I know that may not be possible, so how do I allow the web page to be scrolled horizontally? Like I said, I'm very new to web development and I don't have anyone around me to ask these kinds of questions.