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

2 Likes
Wonderful it’s easy and practical.
2 Likes
system
Closed
4
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.