Merging Cells with Common Contents In Straight Table

[#1]

Hi Friends,

I am trying to use a straight table and want to merge cells with same values. Can this be done?

Attached is the example for your reference and below is the desired output format.

City	Month	Payment
		113820.25
London	Jan	933.75
	Feb	3093.75
	Mar	228.5
	Apr	622.5
	May	2062.5
	Jun	900.75
	Jul	1909.5
	Aug	17740.5
	Sep	17743.5
	Oct	342.75
	Nov	933.75
	Dec	228.5
New York	Jan	600.5
	Feb	1273
	Mar	11827
	Apr	11829
	May	228.5
	Jun	622.5
	Jul	2062.5
	Aug	900.75
	Sep	1909.5
	Oct	17740.5
	Nov	17743.5
	Dec	342.75

Thanks in advance.

Regards,

[anbu1984]

Try Pivot table

[sivarajs]

Use pivot table in this case

[#4]

Thanks for the response, however I will be adding Pick dimensionality for this table; as far as I know this is not possible using pivot tables

[JonnyPoole]

Its the default for a pivot table but see below to do this in a straight table.  The key formatting technique is using the argb() color function . When the first parameter is 0 it indicates complete transparency.