Joining Multiple Tables by Row
Greetings, I’ve been beating my head for long enough with code that should be quite simple. I would like to take tables opened from multiple excel file and sheets and join them in a wide table with columns that are named to correspond to their excel sheet. In my case, columns should be as shown below. Col 1 of TestWB1Sheet1Col 2 of TestWB1Sheet1Col 3 of TestWB1Sheet1Col 1 of TestWB1Sheet2......