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:
Wonderful it’s easy and practical.
