Using transpose or other way to make a table

Hello,

is there any chance to make the table in sheet "PL_FORM" transposed to the table in sheet "AS_FORM" automatically? I've tried everything I know but nothing does the trick

Please help me

Thanks in advance,

Cheers.

Perfectly worked! Actually I didn't know that there's something called Power Query in Excel, I learned now thanks to you!!
but I have this problem now:
after I make the query and load the produced table made by Power Query, when I make some changes in values or Box Numbers I have to redo the process and copy/paste the new produced table by Power Query, is there any way to make Power Query refresh by itself on my target sheet without producing a new sheet in by Power Query?

I really really thank you very much.

There is solution based on formulas

Hello BMV,

I would like to thank you very very much for your efforts, I learned new functions which I didn't know before.

Thanks again for your help.

Reputation added.