Hi all, I have multiple excel files which have the same format and I would like to join them instead of union. How do I go about doing this besides manual inputting every file and join multiple? E.g File A A111100010 E.g File B B110011101 E.g Output AB111110100101011001 All excel files have the same number of rows and I have about 50 of these files. Thank you!

Help required for joining multiple excel with single sheet and same format

Hi all, I have multiple excel files which have the same format and I would like to join them instead of union. How do I go about doing this besides manual inputting every file and join multiple?

E.g File A

A
1
1
1
1
0
0
0
1
0

E.g File B

B
1
1
0
0
1
1
1
0
1

E.g Output

A	B
1	1
1	1
1	0
1	0
0	1
0	1
0	1
1	0
0	1

All excel files have the same number of rows and I have about 50 of these files. Thank you!

Help

Join

Accepted answers

vizAlter

Hi @Eug_teng — Hope this will be helpful:

If this solves your issue please mark the answer "Solved" with a Like, if not let me know!

Arrange in side by side data from various files__vA.yxzp

Arrange in side by side data from various files__vA.yxmd

All comments

vizAlter

Hi @Eug_teng — Hope this will be helpful:

If this solves your issue please mark the answer "Solved" with a Like, if not let me know!

Arrange in side by side data from various files__vA.yxzp

Arrange in side by side data from various files__vA.yxmd

grazitti_sapna

Hi @Eug_teng , this can also be done using multi row formula.

Input tool configuration, replace the path with your path and output file name as field should be set to file name only.

If it helps mark this post as solution.

Thanks.

joining multiple excel-GS.yxmd

Eug_teng

This works! Thank you!

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335