Hello, I am struggling to get a solution where the structure is not static like below. I tried multi row formula, but it was giving a syntax error. Conditions 1. Need the concatenated data to be in the 1st row of the sequence start. Here it is "A" in record 1, which is a key and separator from next block of data 2. It is 2 rows of data sample that needs to be brought in this format and then it has to be separated. Output 2 given below Record #InputOutput1A*15A*15|B*16|C*17|D*19|E*ab|F*45|G*def|H*DTP|I*4562B*16 3C*17 4D*19 5E*ab 6F*45 7G*def 8H*DTP 9I*456 10A*LEA*LE|B*RS|C*45|D*32|E*123|F*124|G*156|I*129|11B*RS 12C*45 13D*32 14E*123 15F*124 16G*156 17I*129 2nd output OutputABCDEFGHIA*15|B*16|C*17|D*19|E*ab|F*45|G*def|H*DTP|I*456A*15B*16C*17D*19E*abF*45G*defH*DTPI*456A*LE|B*RS|C*45|D*32|E*123|F*124|G*156|I*129|A*LEB*RSC*45D*32E*123F*124G*156 I*129 Thanks Naga

Hi @Naga, Attached the complete solution from your input INput Record #Input1A*152B*163C*174D*195E*ab6F*457G*def8H*DTP9I*45610A*LE11B*RS12C*4513D*3214E*12315F*12416G*15617I*129 to this output Let me know if you have questions Best, Vianney

Need to concatenate single column data

Naga

Hello,

I am struggling to get a solution where the structure is not static like below. I tried multi row formula, but it was giving a syntax error.

Conditions

1. Need the concatenated data to be in the 1st row of the sequence start. Here it is "A" in record 1, which is a key and separator from next block of data

2. It is 2 rows of data sample that needs to be brought in this format and then it has to be separated. Output 2 given below

Record #	Input	Output
1	A*15	A15\|B16\|C17\|D19\|Eab\|F45\|Gdef\|HDTP\|I*456
2	B*16
3	C*17
4	D*19
5	E*ab
6	F*45
7	G*def
8	H*DTP
9	I*456
10	A*LE	ALE\|BRS\|C45\|D32\|E123\|F124\|G156\|I129\|
11	B*RS
12	C*45
13	D*32
14	E*123
15	F*124
16	G*156
17	I*129

2nd output

Output	A	B	C	D	E	F	G	H	I
A15\|B16\|C17\|D19\|Eab\|F45\|Gdef\|HDTP\|I*456	A*15	B*16	C*17	D*19	E*ab	F*45	G*def	H*DTP	I*456
ALE\|BRS\|C45\|D32\|E123\|F124\|G156\|I129\|	A*LE	B*RS	C*45	D*32	E*123	F*124	G*156		I*129

Thanks

Naga

Help

Accepted answers

vmartinez

Hi @Naga,

Attached the complete solution from your input

INput

Record #	Input
1	A*15
2	B*16
3	C*17
4	D*19
5	E*ab
6	F*45
7	G*def
8	H*DTP
9	I*456
10	A*LE
11	B*RS
12	C*45
13	D*32
14	E*123
15	F*124
16	G*156
17	I*129

to this output

Let me know if you have questions

Best,

Vianney

concatenate single column data.yxmd

Naga

Thanks @vmartinez ...solved my problem...I am learning lot from this group....:)

All comments

vmartinez

hi @Naga,

attached the workflow that allows you to concatenate the data.

You need to add the multirow formula to avoid having empty rows after using the cross tab

Let me know if you have any questions

Best,

Vianney

concatenate single column data.yxmd

Naga

Hi @vmartinez ,

Thanks for the quick response. I got the answer for my 2nd output. however, need solution for this to get concatenated.

INput

Record #	Input
1	A*15
2	B*16
3	C*17
4	D*19
5	E*ab
6	F*45
7	G*def
8	H*DTP
9	I*456
10	A*LE
11	B*RS
12	C*45
13	D*32
14	E*123
15	F*124
16	G*156
17	I*129

Output

Record #	Input	Output
1	A*15	A15\|B16\|C17\|D19\|Eab\|F45\|Gdef\|HDTP\|I*456
2	B*16
3	C*17
4	D*19
5	E*ab
6	F*45
7	G*def
8	H*DTP
9	I*456
10	A*LE	ALE\|BRS\|C45\|D32\|E123\|F124\|G156\|I129\|
11	B*RS
12	C*45
13	D*32
14	E*123
15	F*124
16	G*156
17	I*129