Its difficult for me to picture. Is it 20 columns and 100 rows, or actually 100 columns with data on.a single line? If your data table is 3rd normal form, you should be able to do something with a pivot table. If your data isn’t, then the data model is probably questionable.
If you can send over a sample, I could take a look. I expect that there are others in here more knowledgeable who could help you.