Hello, I need to change the names as per below
Current data | output |
A, B C | B C A |
A, B | B A |
Hey @ag72,
There is realy no practical way to change something like this within a cell without any specific logic.
The easiest approach for this is prob. a mapping table using a File Input/Text Input and a Find Replace Tool.
@ag72 Is there any specific pattern are you following to get your output?