Merging two rows

[Ekta]

Hello everyone, 

I am stuck at a point in my workflow and need your kind help, please help me with the formula to combine two rows.

Input-

Field 1

by: 01

Nov 2021.

Output -

Field 1

01 Nov 2021

Thank you so much in advance

[Rupal03]

Hi @Ekta 

The solution is really simple. You simply have to join the two fields by a "+" sign and you will get your desired result. I am attaching the screenshot for your reference.

[Ekta]

@Rupal03 Thank you for your reply, but my values are in same column and 2 different rows , and i want to combine them together. Possible if you can help me with the formula please

[afv2688]

Hello @Ekta ,

would this work for you?

Regards

[Matthew]

you can use the crosstab tool to bring them onto the same row and concatenate

@afv2688's method also works

[Ekta]

@afv2688 Thanks so much , this is perfectly working fine - Can i also check please lets say if we have more values 

Field 1

ABC

QWERTY
by: 01
Nov 2021.

and required output is -  

Field 1

ABC

QWERTY

 01 Nov 2021

How can we modify the WF please, 

thanks so much in advance

[Matthew]

how about this

[afv2688]

Hello @Ekta ,

how like this?

Regards

[HomesickSurfer]

Hi @Ekta 

Keep it simple:

IF StartsWith([Row-1:Field 1], 'by:') THEN Right([Row-1:Field 1], 2)+" "+TrimRight([Field 1],'.') ELSE [Field 1] ENDIF

[danilang]

hi @Ekta 

The various solutions provided here work, but you may need to look earlier in your workflow to find why you end up with this

Field 1

by: 01

Nov 2021.

Is this in your input data, or is does your input data look like "Field 1 by: 01 Nov 2021."  and you're trying to split the fields?

Dan