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 · Accepted solution]

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 : )

[binuacs]

@cutehappybear Another option

[Christina_H]

Here's a similar approach that also renames the fields:

[RolandSchubert]

Hi @cutehappybear ,

I'd like to add another approach - using Text To Columns to split the value field and the Arrange tool to organize the result in rows could also be a solution.

In the Arrange tool, you can select a key field (ID) and add columns (only one with values)/ descriptor columns.

You add a column and assign both fields (value1 and value2, the result of the Text To Columns split) to that column as "rows".

You can fill the "Descriptor Column" manually for the resulting rows.

Hope this is helpful.

Best,

Roland

[atcodedog05]

Happy to help : ) @cutehappybear 

Cheers and have a nice day!