How to merge text data if there is same reference value? Prefer the output to be in new worksheet and linked to source (so if the source is changed, the result is automatically change as well)

Here the example of source, you can see Ord Number for row 3 and 4 are same
tanya1.png

And this is the output I expect
tanya2.png


Thanks.