Data delivered in one column, needs to be split into mulitple

[Nitrocide]

I got a problem i can't quite figure out how to solve.

I'm getting data delivered that is all in one column. What i want is to split this up into 3 columns with the interval, heartrate and a letter designation.

So what i need is that Column 2=4000 column3= 55.0, column 4= A on 1 row

Followed by 4000,47.0,A on the next one etc.

[cs_skit]

if your table is strictly ordered in this way always you can use MOD function to check if row is a multiples of 3 with -2 for first value and -1 for second

then you can create second table where you create 3 columns with basically alnternating values because of MOD

[Nitrocide · Accepted solution]

Thanks for the help, it set us on the right track. What we ended up doing was a mod column and a index column that used 1/3 steps. Rounded these down so it created pairs of three of the same numbers. Then pivoted the table to get the format we wanted.

[MFelix]

Hi @Nitrocide,

Select the column where you have the values and choose the pivot columns this will transform your values in the Column one into columns individual columns instead of rows.

Regards

Mfelix