How to copy specific value with conditions?

[Shaopingfu]

I have a table with 2 parts data- Date/Text/Value 1 and 2

How can I use tools to copy Value1 to Value2 for rows where the Date2 and Date1 in one line have same month-year and leave the other cells of Value2 empty? 

Date1	Text1	Value1	Date2	Text2	value2  ( to copy value1)
2023/2/4	abc	123	2023/4/4	nrf
2023/3/8	cdf	222	2023/5/8	ekrhkjr
2023/4/9	1bh	234	2023/6/9	kkl
2023/5/3	igi;l	780	2023/6/3	jkjkhfu
2023/5/15	njfi	8897	2023/7/15	dkw
2023/7/3	khfdljg	1233	2023/7/25	pwer	khfdljg
2023/7/9	ggre	2423	2023/8/3	fjh
2023/8/5	vfff	687	2023/8/12	ue	vfff
2023/9/1	jhrt	878	2023/8/22	mcd

[flying008]

Hi, @Shaopingfu 

FYI.

1- From [Text1] :

IIF(DateTimeParse([Date1],'%Y-%m') = DateTimeParse([Date2],'%Y-%m'), [Text1], Null())

2- From [Value1] :

IIF(DateTimeParse([Date1],'%Y-%m') = DateTimeParse([Date2],'%Y-%m'), [Value1], Null())

[binuacs]

@Shaopingfu One way of doing this