I’m trying to turn a table with a lot of repeated information in each of the rows into a more condensed version with less duplicates.

Within a Query, the main option I see is “Aggregate”. However, for the “Group By”, option I’m only limited to use one column for this and lose access to the rest of the columns that I’m trying to access. Is there a workaround for this or another way that I can condense the table?