I see, for now, there may be a custom code solution that lets you do so. Are the values in the header column unique or are you also looking to do some aggregation?
Some of the threads here have approaches people have taken, like this one dating back to 2019, or this workaround for a crosstab table. There are also some external threads like this post that have some interesting and fairly generic SQL solutions for doing pivots.
That's by no means an exhaustive list though! If you can share a bit more about how your data is structured we can help look for more specific solutions 