Sort text in a cell in a field

[ZoeM]

Hi SME's!

I have a rudimentary example below, I want to sort the data in a cell from oldest to newest (date) and add a row between date entries (before the next date entry)?

Thanks for any suggestions and ideas!!

Data Field 1

Michael, George on Monday February 6, 2023 11:44 PM: Music Station Approval Status: Approved Bar Station Approval Status: Approved Patton, Dolly on Wednesday, March 22, 2023 11:53 PM: Stage Approval Status: Pending Approval Jackson, Michael on Thursday, May 4, 2023 10:21 PM: Backup dancers Approval: Approved Microphone Pieces Approval: Approved Advertising Approval: Approved Vocals Practice Approval: Approved

[binu_acs]

@ZoeM can you screenshot your expected result here for a better understanding?

[ZoeM]

Absolutely:

Expected Result

Jackson, Michael on Thursday, May 4, 2023 10:21 PM: Backup dancers Approval: Approved Microphone Pieces Approval: Approved Advertising Approval: Approved Vocals Practice Approval: Approved Patton, Dolly on Wednesday, March 22, 2023 11:53 PM: Stage Approval Status: Pending Approval Michael, George on Monday February 6, 2023 11:44 PM: Music Station Approval Status: Approved Bar Station Approval Status: Approved

[binu_acs]

@ZoeM one way of doing this

[flying008]

Hi, @ZoeM 

Another way for you:

Output

Jackson, Michael on Thursday, May 4, 2023 10:21 PM: Backup dancers Approval: Approved Microphone Pieces Approval: Approved Advertising Approval: Approved Vocals Practice Approval: Approved Patton, Dolly on Wednesday, March 22, 2023 11:53 PM: Stage Approval Status: Pending Approval Michael, George on Monday February 6, 2023 11:44 PM: Music Station Approval Status: Approved Bar Station Approval Status: Approved

[ZoeM]

I think this will work.

However, I have multiple rows of data, and I cant seem to get it to work...any ideas?

[binu_acs · Accepted solution]

@ZoeM updated workflow attahed

[ZoeM]

Thanks for all the help!