access query to import to excel
 

Hi. I have an exel table that list dept numbers various times due to
various equipment related to these depts. Is there a way to show the
dept one time with the various equipment info? I tried to do this as a
query in access but was not successful. Thanks.