Split the rows and columns as mentioned below and also append the text.

[Mohd-Siddiqui1]

Hi there,

Could anyone help me to implement a workflow which takes below input and produce certain output which is also mentioned below. 

Input:-

RecordID	Value
1	1. Abcdef
2	This is first dummy text line
3	this is second dummy text line.
4	This is third dummy text line.
5	2. Xyz
6	This is first dummy introduction line,
7	this is second dummy introduction line
8	this is third dummy introduction line
9	this is fourth dummy introduction line.
10	3. Pqrst
11	This is dummy text line
12	this is another dummy text line.

Output required:-

RecordID	Value1	Value2
1	1. Abcdef	This is first dummy text line this is second dummy text line. This is third dummy text line.
2	2. Xyz	This is first dummy introduction line, this is second dummy introduction line this is third dummy introduction line this is fourth dummy introduction line.
3	3. Pqrst	This is dummy text line this is another dummy text line.

[Sebastiaandb]

Hi @Mohd-Siddiqui1 ,

Here you go!

Let me know if this works for you!

Greetings,

Seb

[Christina_H]

Here you go.  I added some numbers to one row of your data to make sure I was correctly picking up numbers from the start of a row only.  I've used that to identify the start of each group and the row to separate from the group - it won't work if there are other rows that start with numbers, you would need a different way to identify the right ones.

[Mohd-Siddiqui1]

Hi @Sebastiaandb,

Thanks for your quick response.

Could you please provide the workflow in .yxmd extension, as I am facing problem in opening .yxzp file.

From the image I could see IsInteger(Left([Value], 1)) in formula tool, where 1 is the length (i guess), but what if the length of integer is more for e.g. :-  17. Abcdefghi

Thanks

[Sebastiaandb · Accepted solution]

Hi @Mohd-Siddiqui1 !

Here you go!

It doesn't matter. All the function does is check whether the first character is a number or not :-)! If so, it takes the value for the flag field. All rows after that get the same flag until it finds another row starting with a number value :-).  

Greetings,

Seb