Quick Sight in How to Append Queries(To transfrom the Rows into Columns)
Hi @sowmya,
You can do it in a table visual by using the transpose option. If you want to do it at the dataset level, currently the only way to do it is by using a custom SQL query.