Around 1260 lines and 5992 collums. It's a lot of data.
Like I said, in one file all of the data is in one single sheet, with each stock seperated by a blank collum. The other has each stock in its own sheet.

Will the pivots tables work in this case?