Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in


Batch copy and transpose multiple CVS files into a single summary Excel sheet

1 year 5 months ago #281 by Jay Chivo
Sorry, we don't have such function yet.
Please try to post your question after the article.
The author may try to help you.

Please Log in or Create an account to join the conversation.

  • Attila Jantsek
  • Topic Author
  • Offline
  • New Member
  • Nouveau membre
1 year 5 months ago #274 by Attila Jantsek
Hi All,

This is my first question at this forum because I come across a real head scratcher..

I am trying to adapt a VB code, published at How to quickly batch import multiple csv/text/xml files in Excel? to import multiple CVS files from the same directory and place them transposed into a single Excel worksheet.

The source files are all located in the same folder.
There are 3 columns of data in the source files, but only 1 column need to be imported,
The imported data is to be transposed and placed in the next empty row on the target worksheet.

My modified code is so messy that I do not even want to paste it here,but you can find two sample input CVS files and a desired output XLSX file attached.

Thanks for all help in advance.

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Moderators: jaychivoJay Chivo