How to match quarter data with the correct quarter?

[Waimea]

Hi,

I have a data table with 3 columns, name, value and year and quarter.

Name	Value	Year & quarter
Event A	50	2021 Q1
Event B	45	2021 Q3
Event C	52	2021 Q4
Event D	49	2022 Q2

And I have a table with timevalues:

Timevalue

2021 Q1

2021 Q2

2021 Q3

2021 Q4

2022 Q1

2022 Q2

2022 Q3

How can I in a easy way (with VBA) place the events at the right place in my timetable?

Timevalue	Name	Value
2021 Q1	Event A	50
2021 Q2
2021 Q3	Event B	45
2021 Q4	Event C	52
2022 Q1
2022 Q2	Event D	49

All suggestions are very welcome!

 

[kvsrinivasamurthy]

What is the expected result.

 

[Waimea]

Timevalue	Name	Value
2021 Q1	Event A	50
2021 Q2	Event B	46
2021 Q3	Event C	39
2021 Q4	Event D	41
2022 Q1	Event E	48
2022 Q2
2022 Q3	Event F	51
2022 Q4
2023 Q1	Event G	48
2023 Q2
2023 Q3

This is the expected result, event D is changed from Q3 to Q4.