Filter ROWS Type Series

[pollyste]

Hi,
I have a column where there are many types values,
but they repeat in series:

1.String - name
2.INT
3.Date
4.String -description
5.String - name
6.INT
7.Date
8.String - description
…

How i can extract for example Int values or Date from a series in a column like this?

[tommy]

hi @pollyste

you might think of pivoting using 2 Math Formula in combination with Pivot.

Output:

But quick & dirty use a String manipulation and a String to Date&Time:

Take into account that your Date has strictly a consistent format.

Output:

[pollyste]

Wonderful it’s easy and practical.