Basic Table

[Sarath27]

Hi All.

Submission Type	Region CF	Prod Level6 PR	P C	Total
FV	Europe	EMEA	47410-2238	2
FV	Asia Pacific	APAC	17462-7758	4
FV	Europe	APAC	89514-2338	6
FV	United Kingdom	EMEA	13687-2772	0

My required output should be below

Submission Type	Region CF	Prod Level6PR	P C	Total
FV	Europe	EMEA	47410-2238	2
APAC	89514-2338	6
Asia Pacific	APAC	17462-7758	4
United Kingdom	EMEA	13687-2772	0

I have tried with Basic Table, but it didn't come out well as expected. I want the final output to be working just like excel where user can filter the columns.

Please help me achieving this. Thanks in advance.

Thanks,