I have been trying to understand the "let function" and need direction if this what I should be trying to use.
Trying to make a solution from multiple records with the same product number and list the critic review in one field.
The amount of records vary as well as the reviews.
This is what I am trying to achieve;
|Record ID||Item Code||SCORE||RESULT I WANT - CALCULATION TO COMBINE ALL RESULTS|
|1||LGD100||92PTS ROBERT PARKER||92PTS ROBERT PARKER, 93 WINE ENTHUSIAST, GOLD MEDAL|
|2||LGD100||93 WINE ENTHUSIAST||92PTS ROBERT PARKER, 93 WINE ENTHUSIAST, GOLD MEDAL|
|3||LGD100||GOLD MEDAL||92PTS ROBERT PARKER, 93 WINE ENTHUSIAST, GOLD MEDAL|
Will I need to use a script or a calculation can make this work?
Thanks for help.