Table Transormation

Hello,

I'm quite a newbie, I usually try to find solution first from research but I don't even know what to look for with what I want to achieve which is something like this.

What I do currently is to create multiple queries out of the same table, filter out columns and reassemble each through new query>combine>append queries as new. Its very repetitive and tiring when there are a 100 items that needed to be transformed.

Thanks in advance!