Pulling specific columns by transpose two headers

[deniztopcu]

I want to pull the last 5 quarter data of "Symbol and itemcode" from the table.
Symbol and item code" must be transpose.

Pulling specific columns by transposing two headers

I want to reach an image like the first picture so that I can compare.

How can we solve it in the shortest possible way, with the fewest formulas.

 

[Fluff]

Duplicate to: Pulling specific columns by transpose two headers

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.