How to display value only once using a pivot table for a column?

[ngovula]

Hi, We have a requirement as to display the value of column only once . Could you please let me know how to avoid repetitive values.  Auto should be displayed only once under customer Vertical. 

Customer Vertical	year	Tatal amount
Auto	2016	100k
Auto	2017	200k
Auto	2018	250k
Auto	2019	400k
Auto	2020	500k

[Kushal_Chawda]

Did you try creating pivot table? Pivot table shows values once.

[ngovula]

Yes, we used it in pivot table.

[Kushal_Chawda]

would you be able to share sample?

[ngovula]

Customer Vertical	year	Tatal amount
Auto	2016	100k
	2017	200k
	2018	250k
	2019	400k
	2020	500k

This is how i want to display.

[Babu_3103]

i am Also Having same concern