Split data and join them together

[niteshsharma677]

Hi Everyone,

I need to convert following input to following output. How can I achieve this ?

Input

F1	F2	F3
Sub	1st attempt	1st attempt passed
Eng	45	34
Math	56	32
Sub	All attempt	All attempt passes
Eng	56	23
Math	44	22

Output

Sub	1st attempt	1st attempt passed	All attempt	All attempt passes
Eng	45	34	56	23
Math	56	32	44	22

[ShankerV]

Hi @niteshsharma677 

Step 1: Use Multi row function to numbering

Step 2: Use Filter tool

Step 3; Join the datasets

Many thanks

Shanker V

[niteshsharma677]

@ShankerV 
Thanks for your input.
What exactly to be done in the multi row function ?

[ShankerV · Accepted solution]

Hi @niteshsharma677 

One way of doing this.

Step 1: Input

Step 2:

IF [F1]="SUB"
THEN [Row-1:Temp]+1
ELSE [Row-1:Temp]
ENDIF

Step 3:

Step 4:

Many thanks

Shanker V

[niteshsharma677]

Thanks a lot @ShankerV  !