Merge text files adding a column with filename

Job ID: 32526785

Budget: €8 – €30 EUR

I need a simple batch or powershell script to merge a bunch of txt files, comma separated. I need a new column to be added with the filename of each file (only name, no extension). There are many examples on the web but most of them have issues
Related categories: Shell Script Powershell