Dear experts,
I have a long list of students and assessment item results. The last column
is a comments column for my use. I enter short descriptions of
recommendations here. Not every student has a comment. I would like to be
able to extract out the details of the student (id, name, surname) along with
the contents of the recommendation column (text). I have made some attempts
with vlookups but I cannot omit the students without comments with this
method. Do I need an array formula? Your assistance would greatly shortcut
my efforts in summarising this data.
kind regards
Molly