I've imported the three excel tables, and I've made it so that the primary key column names match each other. I need to find a way to link them into one table or form/report so I can easily update them for the future, since updating each individual sheet in excel was getting tedious. Also, I have multiple repeats of column names, for example:
Company XXX
Company XXX
Company XXX
Company XXX
Company ABC
Company ABC
Co W
Co W
Co W
I want to find a way to condense this so that only one company name pops up for each company, and then by clicking on that one name I can access all of the information behind that company as well. Any help is appreciated