Filter ROWS Type Series

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?

hi @pollyste

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


Output:
grafik

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:
grafik

2 Likes

Wonderful it’s easy and practical.

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.