Combine values across different columns

[tww]

Hi all,

I am new to Alteryx and I am trying to combine values across different columns. (See below). I am not sure where to start.

Input

Access_Control	R01#R02
ACCT_OPS	R01
ACQ	R01#R02#R03

Output

Access_Control	Access_Control.R01#Access_Control.R02
ACCT_OPS	ACCT_OPS.R01
ACQ	ACQ.R01#ACQ.R02#ACQ.R03

Thank you in advance for your assistance.

[martinding · Accepted solution]

Hi @tww ,

There are multiple ways to achieve the desired output.

Please find attached:

[Yoshiro_Fujimori]

@tww ,

One way of doing this.

Steps

1. Text To Columns : split by rows

2. Formula : concatenate the two strings

3. Summarize : combine the strings with Group by Col1.

Formula

Output

I hope this might help.

[tww]

Thank you, @martinding 

[tww]

Thank you, @Yoshiro_Fujimori