would you please advise if there's a way in Excel to aggregate data from specified columns of another sheet? I got 3 columns in sheet A, where data is dynamical - changed manually on a regular basis. I'd like to gather these manual entries in a separate sheet B, exclude duplicates and use it for further vlookups. I've tried Power Query and it's now possible to capture the current state of 3 columns from sheet A, but I can't come up with solution to aggregate and remove duplicates within data refresh. Appreciate your help
CodePudding user response：
find the information here 
Three different ways to aggregate (depending on your aggregation goals):
Group By: (for grouping based on a category or count)
Merge Columns: (for making a "comma-separated" list of values between two or more columns)
Custom Column: (for calculated column such as a SUM on multiple columns into one)
