Need to create report from pivot format

[asaradkar_2609]

Hi,

Need help to create report from pivot table format.

Having date is in below format.

Market	City	City ID	YearMonth	Value	#  Number	Value	#  Number
Market A	city1	3030	202206	3459	1	76567.66	11
			202207	4646	2	7476565.9	22
			202208	5833	3	14876564.14	33
			202209	7020	4	22276562.38	44
			202210	8207	5	29676560.62	55
			202211	9394	6	37076558.86	66
			202212	10581	7	44476557.1	77
			202304	15329	11	74076550.06	121
			202305	16516	12	81476548.3	132
			202306	17703	13	88876546.54	143
	city 2	2020	202302	28386	22	155476530.7	242
			202303	29573	23	162876528.9	253
			202304	30760	24	170276527.2	264
			202305	31947	25	177676525.4	275
			202306	33134	26	185076523.7	286

Need to create report in below format.

Market	City	City ID	YearMonth	Feedback Code	Feedback	Value	#  Number
			202206	C1	satisfaction	3459	1
				C2	76567.66		11

[robert_mika]

How did you get the Satisfaction value?

Achievable perhaps but needs some work in script.

Can you provide the data and rules?