Filling the blanks

[Anonymous]

[Anonymous]

Material Description	Q1	Q2	Q3	Q4			Material Description	Q1	Q2	Q3	Q4
a	212571		247000	247000			a	212571	212571	247000	247000
b			250384	250384			b	250384	250384	250384	250384
c	240127	247000	292525	247000			c	240127	247000	292525	247000
d	242331	250384	139371	250384			d	242331	250384	139371	250384
e	283901	292525	140579	292525			e	283901	292525	140579	292525
f	126518	139371	160115	139371			f	126518	139371	160115	139371
g	127708	140579	158504	140579			g	127708	140579	158504	140579
h	145742	160115	185593	160115			h	145742	160115	185593	160115
i	144094	158504	236795	158504			i	144094	158504	236795	158504
j	168080	185593	233664	185593			j	168080	185593	233664	185593
k	79062	236795		236795			k	79062	236795	236795	236795
l	79593	233664		233664			l	79593	233664	233664	233664
m	91433						m	91433	91433	91433	91433
n	89203	247000					n	89203	247000	247000	247000
o	103964	250384					o	103964	250384	250384	250384
p	218548	292525	247000				p	218548	292525	247000	247000
q	219932	139371	250384	247000			q	219932	139371	250384	247000
r	250845	140579	292525	250384			r	250845	140579	292525	250384
s	247769	160115	139371	292525			s	247769	160115	139371	292525
T	288833	158504	140579	139371			T	288833	158504	140579	139371
u	221162	185593	160115	140579			u	221162	185593	160115	140579
v	222700	236795	158504	160115			v	222700	236795	158504	160115
w	247000	233664	185593	158504			w	247000	233664	185593	158504
x	250384	233664	236795	185593			x	250384	233664	236795	185593
y			233664	236795			y	233664	233664	233664	236795
aa				233664			aa	233664	233664	233664	233664
ab				247000			ab	247000	247000	247000	247000
ac	160115	247000		250384			ac	160115	247000	247000	250384
ad	158504	250384	247000	292525			ad	158504	250384	247000	292525
ae	185593	292525	250384	139371			ae	185593	292525	250384	139371
af	236795	139371	292525	140579			af	236795	139371	292525	140579
ag	233664	140579	139371	160115			ag	233664	140579	139371	160115
Total	5276170	5392579	5018336	5816415			Total	6240882	6661295	6805276	6652232

[Anonymous]

right table is the outcome  i want to reach

[lbendlin]

Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[Anonymous]

@lbendlin  done