Reverse Switch Text by Delimitator

sslattery17

A few of our clients send reports with last name, first name and I have used the below formula in the past and I used switch to achieve the same result but can't get it to work.  What part of the syntax am I getting wrong or missing?? Attached sample data and screenshot

with Power Q:

Text.Combine(List.Reverse(Text.Split([Resident],",")), " ")  

Using below and creating new column: 

SWITCH([Resident],",")), " ")

Thank you in advance for the assistance.  SS

Screenshot 2024-10-24 073621.png

Sample Data_CR.xlsx

atcodedog05

Hi @sslattery17 

Here is a snapshot

Hope this helps : )

Switch.yxmd