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 |
Solved! Go to Solution.
@ZoeM can you screenshot your expected result here for a better understanding?
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 |
@ZoeM one way of doing this
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 |
I think this will work.
However, I have multiple rows of data, and I cant seem to get it to work...any ideas?
@ZoeM updated workflow attahed
Thanks for all the help!