Parsing the data

[jmedidi]

Trying to get the below to work. Need to filter the numbers as i have records without the row numbers.

Existing	Field
	1
	Date
	15-Oct-20
	2
	Notes Reference
	3
	Engineer's Name
	dummy@gmail.com
	4
	Hardware part number(s) (See note 1)
	XX-FFF-FFFF
Expected Output
	Date	Notes Reference	Engineer's Name	Hardware part number(s) (See note 1)
	15-Oct-20		dummy@gmail.com	XX-FFF-FFFF

[atcodedog05 · Accepted solution]

Hi @jmedidi 

Here is how you can do it.

Workflow:

Hope this helps : )