Split Row in 2 Rows

cutehappybear

Hello,

I have a table that goes like this.

ID	Field	Value
123	Temperature	3,0-23,0
456	Temperature	1,0-20,0
789	Temperature	2,0-21,0
012	Temperature	1,5-25,5

But I want to separate the values using the hyphen and create something like this:

ID	Field	Value
123	Temperature_Min	3,0
123	Temperature_Max	23,0
456	Temperature_Min	1,0
456	Temperature_Max	20,0

I have seen the Text to Column function, I can separate them into rows but I can't change the name of the Fields.

Any suggestion?

atcodedog05

Hi @cutehappybear 

Edit: updated workflow

Here is how you can do it. Use text to column tool like highlighted below and multi-row formula tool.

Workflow:

Hope this helps : )

row.yxmd