I have a column that called "Metric ID" and it contains data as you see below. The problem I'm having comes when I sort. It sorts incorrectly because it's a single line of text.
Correct (Needs to be sorted like this)
I have an idea with calculated columns but not sure how to do it.
I will create 4 calculated columns.
calculatedColumn1 = first value before the period
calculatedColumn2 = 2nd value before the period
calculatedColumn3 = 3rd value before the period
calculatedColumn4 = 4th value after the period
How do I capture each value using a calculated column?