Generate List Of Items in a range

I have a range which contains various data inputs which might occur more than once . The range is named MyRange (see attachment), the size of the range is variable.
I would like to generate a list of the content, as shown in the attachment.
I appreciate any advise.
Thank you

Here's one way

Please Login or Register  to view this content.

Thank you!