In this example I am picked three columns which appear horizontal to other, then sort them and concat with a separator.
Note: I am not an expert in excel so this may not be a simple solution. This I tried on need and it worked :)
Formula in D2
In this example I am picked three columns which appear horizontal to other, then sort them and concat with a separator.
Note: I am not an expert in excel so this may not be a simple solution. This I tried on need and it worked :)
Formula in D2
