Help re-formatting data to be more useful

Question

Hi - I'm very new to Alteryx and I'm trying to learn through videos and trial and error. I've managed to get my data input in better shape, but I'm struggling with the last step. The boxes in the "timestamp" column are hiding employee names - I'd like these names to be in the "Full Name" column for each of the dates. So the name in the first row should be moved to the first column for Row 2 through 6. Hopefully this makes sense! Any advice on how to shift those data points?

Alteryx Screenshot.png

apathetichell · Answer

This assumes you want them a) in your first column (sorry don't remember it's exact name) and b - they are in the timestamp column already (just burried in data). c) there are no people named "first read" in your company/data set.

first data cleanse excess white space on timestamp then in your person category

if !regex_match([time stamp],"\d{2}.*") and !contains([timestamp],"first read") then [timestamp] else null() endif

should move them over... post some actual data if you need more help.