Extracting a cell from a field where it's a date

[Brawlstrogg]

Hi folks,

I've got a field that shows like the below;

01-12-17

Example

Example 2

Example 3

02-12-17

Example

Example 2

Example 3

It's a blend of work items and dates and I can't seem to figure out a way to separate them so it'd look like the following;

01-12-17	Example
01-12-17	Example 2
01-12-17	Example 3
02-12-17	Example
02-12-17	Example 2
02-12-17	Example 3

Any ideas?

[vishwa_0308 · Accepted solution]

Hi @Brawlstrogg,

Please try this workflow attached..hope it will figure out your solution.

Best,

Vishwa

[Brawlstrogg]

I found a work around within the workload I had which is good.

But just tested this and it works as well. Thanks buddy.