As it's difficult without text files relative to the result worksheet or vice versa so :
- according to the first text file in your zip attachment - aka '001_1-202110290837.csv' - in the result worksheet what is the last row # used
in column A and what is the cell content ?
- According to the second text file - aka '002_2-202110290838.csv' - what is the last row # used in colum B and what is the cell content ?
I'm seriously finding it hard to understand what you mean by "text files relative to the result worksheet or vice versa". I'll be glad if you could explain more please.
Nevertheless, I'll make a pictorial demonstration to answer these two questions and make the task clearer. For clear illustration, I'm doing the task manually now but only for the first, second and third csv text files.
The image above shows the original first text file to be worked on, as it is in the dropbox link. The values we need copying to the Result Worksheet is in column E as highlighted, ranging from E5 to E1124 (the above picture didn't cover all the rows). The cell E1124 is where the data ends for this column. It could be noticed that there are repeated or duplicate values, so I will delete every other rows now and round up all values in this particular column to 2 decimal places. The result is presented below and I'll tag it as "processed first text file".
From the above picture of the processed first text file, the duplicate rows have been eliminated and also the values were rounded to 2DP.
Now I will create a new xslx worksheet and name it as Result Worksheet. I'll then copy all the values in column E which now ranges from E3 to E562, to paste in the Result worksheet as shown below.
From above screenshot of the Result Worksheet, the values copied from the column E of the processed first text file has been pasted down the rows of the first column A in the Result Worksheet and also transposed to the columns of row 1. But all these are done after inserting a zero at first, as seen.
I'll repeat same procedure for the second text file.
The above screenshot displays the values in the second text file. The values to be copied are from column E5 to E1122 but they have duplicate rows of data. The cell E1122 is where the data ends for this column. I'll delete duplicate rows and round up to 2DP as I also did for first text file. The result is the below.
The above screenshot is the processed second text file. We'll then copy the column E values from column E3 to E561 where we have the last cell with data for that column. The copied values are pasted in our same Result Worksheet as below.
As seen from above image, the copied values from the second text file are pasted starting from B2, down the rows of column B and same values transposed to the columns of row 2. Remember we will first insert zero.
Doing same procedure for the third text file. Assuming the processing procedures for each text file has been understood, I'll just post the result of the processed third text file.
From the above image, the third text file has also been processed by deleting its every other rows and rounding up the values in column E. The range of copied values for this text file is from E3 to E560, where E560 is the last cell with value. For easy confirmation, I have uploaded the three processed text files to this reply along with the Result Worksheet used for this demonstration.
Pasting these copied values into the same Result Worksheet gives the below.
It can also be noticed in the above image of the Result Worksheet that after inserting zero in C3 for the processed third text file, the copied values are pasted down the column of C starting from C3 and also transposed to the columns of row3. This is how the procedures goes on and on for all the text files.
Kindly let me know in case this explanation hasn't still answered your question. Thank you for not getting tired of my boring explanations.
I'm sorry I didn't see where to upload files to this reply, so I have posted the already processed text files used in this explanation to this link
www.dropbox.com