Transform semi-structured bloomberg data into pivottable table

Hi, I've got semi-structured data that I need to transform in to a table that can be pivoted. Data are yearly prices from Bloomberg and I've got 276 tickers (columns) with about 15 years of data each (rows).

Copying, pasting and transposing the data will take me a loooong time. I appreciate if anyone has tips on how to do it or get started with vba. I did take some VBA courses but this is way over