copy and transpose two arrays to new worksheet and append to existing data

Attached & below is an excerpt from a more involved process. The tab “MasterCSV “worksheet will get overwritten with new data which will contain anywhere from the three companies/tickers I have in my example to hundreds. Fortunately, the dimensions that I want to copy and transpose are consistent. Essentially for each ‘set’ of information for a ticker there are two arrays of info, one which needs to be copied and transposed into “TransposeMaster” (109x11 to 11x109) and the other just copied and pasted into “TransposeMaster” (11x10). I’m pretty early on in my vba knowledge accumulation, so I’m sure my issues are simple for advanced users. There are couple of misused items and objects I’m not sure how to describe:

Please Login or Register  to view this content.

In addition to my transpose issues, how would I introduce a mechanism such that when I have new data overwritten in the “MasterCSV” - when I perform the transpose code the copy/transpose/paste is appended to the “TransposeMaster” starting right after the last row with data?
Thanks in advance for any help!

Wow!

Simplified and elegant, works like a charm, and even does some of the text parsing I was going to research later. I have some new things to research, like Resize.

Followup Question: if I wanted to further modify this such that I don't clear the contents in wsTM, but add to the existing content in wsTM when i have new data in wsCSV how would i do that? /i have already played around with taking out the clear contents line and setting j to start with LastRow instead of 2, but it's apparent i'm not sure how it works exactly.

Anyways this is super helpful I really appreciate it.