I have multiple .txt files that I am able to combine into one big .txt file. What I'd like to do before combining is have each file name be a column inside the .txt file. The filename is a date that is helpful when I eventually export the data into Excel.
When combining the .txt files, the file name does come in as a row...but not a column.
Thanks for any ideas or suggestions.
input
andoutput
.