Karen
It is difficult to answer if that is too many columns. Have you considered multiple tables that are normalized and then bringing each into the Data Model and creating pivot tables in Power Pivot? If you go this route, then make sure that you have common fields in the tables that need to be linked.

__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2510