Splitting data in one column based on a data type?

[jason79121]

Hello,

I have data in one column that looks like the below:

Role

username1

7/27/2023

username2

7/28/2023

I am trying to split it up to keep the usernames underneath the role and put the dates in the column next to the username. It will always be the case that the data below will belong to the username above, similar to this:

Role	Date
username1	7/27/2023
username2	7/28/2023

Is there a way to do this in Alteryx?

[DataNath]

Hey @jason79121, how does this look? We're just splitting the data via a Filter on records that can be parsed to a date (mm/dd/yyyy pattern) and those that can't (the usernames). They'll come out of the Filter anchors in order and so we just conduct a simple join based on record position i.e. row 1 matches to row 1 etc.

[flying008]

Hi, @jason79121 

An easy way for you: