I want to join multi file (or sheet) into one file with same format.
Ex:
Sheet 1 (file 1):
King 1 --King 2
AAA ----- 1
BBB ----- 2
CCC ----- 3
Sheet 2 (file 2)
King 1 - King 2
DDD ----- 1
EEE ----- 2
FFF ----- 3
Result
King 1 ---King 2
AAA ----- 1
BBB ----- 2
CCC ----- 3
DDD ----- 1
EEE ----- 2
FFF ----- 3
Please help me with formula.
Thanks all.
Bookmarks