I need to transpose a custom table. Has anyone done this?

[ashwinipingle]

I have a custom table and want to transpose it. The records are quantity for a given year. I have 10 years. I want to transpose this table. Is it possible to do it in servicenow? 

As a workaround I am doing this in powerbi, however it will be very helpful to create a view from this table that provides a transpose view.

[Maik Skoddow]

What do you mean with "transpose". Please provide an example and/or a better explanation.

[ashwinipingle]

[Laszlo Balla]

If by transpose, you mean rotating data from rows to columns or vica-versa, then technically no, you can't do it. You should redesign your data model.