Multiple columns under single column

Currently I have a table looking like below in Quicksight:

I want it to show like below, have new columns General and dma, so few of the columns go under them and others don’t, for example tt column will not come under anything.

Hey @Quicksight_beginner ,

you could use a pivot table to solve your problem. You table could look like this:


Seems like what you want.

BR
Robert

Hi @Quicksight_beginner,
As it’s been awhile since we’ve heard back from you, it seems like Robert’s solution worked for your question. I’ll go ahead and mark as the solution but if you have any additional questions, feel free to let us know or create a new topic for discussion.

Thank you!