Hi,
I'd like to extract data from all the text files in a folder into individual columns using VBA

lets say 2 text files in this location "C:\Users\jonny\Desktop\test\" - textfile1 contains A,B,C and textfile2 contains D,E,F (each letter is on a seperate line in their respective text file) - I'd like the output to look like this:


column A column B
A D
B E
C E