Forum Discussion
Solved
Add Column based on VLOOKUP and CONCATENTATION
I am looking to add a new column based on looking up an opportunity number and concatentating the products from another column. A comma would be used to separate each Product Code. Here is an ex...
Hi Alicia,
Think this might give you the desired result (just check the column names first):
= Table.Group(#"Renamed Columns", {"Opportunity"}, {{"Count", each Table.RowCount(_), type number},{"ProductCode", each Text.Combine([ProductCode],","), type text}})
Below is my desired outcome. Instead of having an Opportunity # listed multiple times due to multiple Product Codes, I would be able to show the Opportunity # with all the Product Codes in one cell in the next column.
Opportunity # Product Code
195314 727, 721, 840
