Adding filename inside table excel and merge
5 views (last 30 days)
I don't know it is possible, but I don't remember.
I have several excel (.xslx) almost 3000 file. I would like to insert filename inside table adding one column.
I put one example, these are file excel:
Each excel file has two variables (data and rainfall). for example 'filename1.xlsx':
I would like to put another variable (column) with the filename, in this case is filename1
Maybe using "for"? I don't know
And then it is possible to merge all excel file creating one master excel file?