Merge two list (as text)


I have a simple question :
I have 2 lists (text type) with the same amount on items. I would like to merge the 2 values into 1.

List 1 = A, B, C
List 2= D, E, F

New list : AD, BE, CF

(If possible, I would like also to be able to add a custom piece of text between the 2 values, ex : A_D, B_E, C_F)

How can I do that?

This topic was automatically closed after 70 days. New replies are no longer allowed.