How to concatenate one record with the remaining records from the same column?

[AYESHASIDIKHA]

Suggest me how to concatenate one record with the remaining records.

For example, If I have thousand records then one record should concatenate with the remaining records.

This is the dummy data, Please help me in solving this

INPUT:

col A	Col B
00	A
01	B
02	C
03	D
04	E

Expected Output:

Col A1	ColA2	ColB1	ColB2	Relationship
00	01	A	B	00_01
01	00	B	A	01_00
00	02	A	C	00_02
02	00	C	A	02_00
00	03	A	D	00_03
03	00	D	A	03_00
00	04	A	E	00_04
04	00	E	A	04_00
01	02	B	C	01_02
02	01	C	B	02_01
01	03	B	D	01_03
03	01	C	B	03_01
01	04	B	E	01_04
04	01	E	B	04_01
02	03	C	D	02_03
03	02	D	C	03_02
02	04	C	E	02_04
04	02	E	C	04_02
03	04	D	E	03_04
04	03	E	D	04_03

[FrederikE]

Hey @AYESHASIDIKHA,

You can use an "Append" tool with both inputs from the same source.

[ShankerV · Accepted solution]

Hi @AYESHASIDIKHA 

One way of doing this.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @AYESHASIDIKHA 

Step 1: Input data

Step 2: 

Step 3: 

Step 4: 

Step 5: 

Step 6:

Many thanks

Shanker V

[AYESHASIDIKHA]

Thank you Everyone, It really helped me. 

Also, I would like to know if I have 2989441 records i want output in excel, Only few records are getting in the output file remaining are getting truncated. How to deal with? 

Thanks in advance

[ShankerV]

Hi @AYESHASIDIKHA 

You can overcome the issue of truncation by saving the file in .CSV format

Many thanks

Shanker V

[AYESHASIDIKHA]

Hi,

Thankyou for the solution, i want the output in a particular order which i have mentioned in the expected output.