When duplicate data is in different columns different rows, how can I put them into same row ?

Question

For example - Here in B4 box is E3 box the Staff/AgentCode is same but in different rows, I want to bring both of the data in same row. I mean either E3 and F3 should come to E4 and F4, or the B4 & C4 data should come to same row with B3 & C3. This is part of big data, I cannot do it manually.

B	C	D	E	F
Staff/AgentCode	Jan-23		Staff/AgentCode	Feb-23
B518396	1		B524572	116
B524572	128		B530015	72
B530015	78		B540715	7
B540715	16		B624297	39

Answer 1

This is part of big data,

Does all source data in one sheet or in two seperate sheets?

Answer 2

Excel 365 Pro Plus with Power Pivot and Power Query.

To visualize massive data without formulas.

With Pivot Table and Pivot Chart.

https://www.mediafire.com/file_premium/1v7lr8mdvc8yuu9/12_10_23a.xlsx/file

https://www.mediafire.com/file_premium/gjyne0oo2nv1i8i/12_10_23a.pdf/file

Answer 3

I'd do it like this:

In D1: Feb-23

In D2: =XLOOKUP(E2, $B$2:$B$10000, $C$2:$C$10000, "")

Fill down from D2.