Table Split: how to move the suffix before the original column names? Temperaruer Step 1 vs. Step 1 Temperature

[#1]

Hello, I want to get some advice for splitting table. Thank you!

I have two columns A and B

A: Temperature 

B: Step 1 / Step2 / Step3

I split column "temperature" by column "steps". The final column names are "Temperature Step1", "Temperature Step2"...

How could I make final column name starts with suffix steps? like "Step1 Temperature", "Step2 Temperature"? I got a lot of columns so it is difficult to edit manually. 

Thanks! 

[#2 · Accepted solution]

You can edit your B column (or create new) in your original data table before split (change formula to "Temperature " || :B)

Or you can use recode column names with regex for example

With ^ you can "replace" start of the string and then replacement text is "Temperature "

Or you can write a script

[#3]

@jthi  Thanks! That's exactly what I am looking for and it works very well!