Yes. It's called a Crosstab Query. Expert 17.

Thank you for your response. I watched the preview but it is not what I am aiming for. For example:

Name            Weight
Product 1           1kg
Product 2           2kg
Product 3           3kg

I want to turn it into.
Name       Product 1        Product 2               Product 3
Weight       1kg                     2kg                      3kg

In addition, I want to be able to filter columns like for instance, I only want to see products with 1kg weight.

Really hoping to get a solution. Even if it is not using Access and using other software is fine. Thanks in advance.

What you want is a feature called Transpose Axes. Access doesn't have this as a native feature, but Excel does. Just select your range, Copy, and then Paste Special. Select the Transpose checkbox. I cover this in Excel Expert 8. It's possible in Access, but it involves a lot of work and programming.

I see. Do you have a course that tackles how to filter columns using data validation? I saw an article about it but since I am not a VBA expert, it would be great if there is a more detailed explanation on how to use it. Heres a link to the article for your reference. Thank you.  https://www.atlaspm.com/toms-tutorials-for-excel/toms-tutorials-for-excel-filtering-by-columns/

Are you trying to do this in Excel or Access? I do cover filtering in Access in several different classes, including my free Access Beginner Level 1 class. Beyond that, yes, I've got filtering, sorting, searching, you name it. It's something I take a lot of time to cover in many different lessons. The best one would be my Search Seminar.