I think this will save me another column for first lookup data, and then create a template column to put the word "from " in front of the shop name.
I wonder if the implementation would be as same as how a Number (column type) could have “units” as prefix/suffix for the currency unit.
I will leave this to you. Just an idea I think it’s a small effort with huge impact in save more data & neater table.
Thank you.