How to get past 'not knowing' syntax: Use the fx option on formula tool based on the data type 'string', it's a long list but for others, you always have the community
[Spolier] Join on Record Position: How do I append two or more columns on a single row? Use Join by Record Position