Extracting data and transposing from power pivot

[nekmat97]

Hello,

I want to extract a range of data and then transpose the data and then place it in a specific cell (B2 for example) and then extract data from a range further down that column and do the same but place the data in C2 etc. The data comes from a query which has been opened up with Power Pivot and cleaned. The range between the data that I need is the same.

Thanks