transpose data

[Afarag]

Hello there,

please I need your support as I have a table which needs to transpose the data vertically.
I want to transpose some of columns not the all table column, but each row will be transposed at autonomous table like the data that located at "Transpose" worksheet.

thanks a lot,

 

[Hui]

On the Transpose Sheet B2:
=IFERROR(OFFSET(Data!$A$1,1+(ROW()-2)/7,MATCH($A2,Table2[#Headers],0)-1),"")
Copy down to B84

 

[Afarag]

Hi Hui,

it worked fine

thanks a lot sir