Importing multiple CSV files and transposing contents into successive rows

Hi, new to the forums and pretty much joined to get help with this.

I have ~500 dpt files that I need to import into excel and organize from columns into rows.
Previously I have used the text importer and then copy and pasted the data using the transpose function into rows, organizing it as I go, but this was done with at most 20 files and takes some time to do (also is very tedious).

The data is arranged in two columns of 2307 rows which I need in 2 rows of 2307 columns.
All the files are in the same location and have numerical designations
The example excel file shows the format I am going for (it has 5 data entries while I could only provide 4 txt files)
Also, the txt files native format is .dpt which I had to change to .txt to upload.

I tried using the record function to generate a macro as I have no Visual Basic experience and all I was able to do was get Excel to transpose the data automatically (had to manually import the data) but it would overwrite the previously imported data with each new data import.

Any help would be appreciated! I'm not even sure if something like this is possible...


Edit: Thanks moderator for pointing out issue with title!

Strupo,

Welcome to the forum!
[EDIT]: Thank you for changing your title

With that business out of the way, can you provide a couple sample csv files as well as an Excel file that would show the desired results?
To attach a file, click the "Go Advanced" button and then click the paperclip icon to open the Manage Attachments dialog.

Strupo,

This code accomplishes the goal successfully using the sample files:

Please Login or Register  to view this content.

You're very welcome