Split data into two halves based on column values

[Saved]

I was looking for code that will automatically split data into equal halves and copy paste next to each other. The criteria is based on two columns-Date and Shift.

Eg.
A) 27/06/2024-Shift 1 has 422 rows, then Sl. 01-211 should be on the left and 212-422 should be on the right.
B) 27/06/2024-Shift 2 has 420 rows, then Sl .01-210 should be on the left and 211-420 should be on the right.

It should loop the same exercise for the remaining dates/shifts based on the number of rows for those. I have done it manually in the example, but it's a nightmare once there are many dates and shifts.
PS: Unable to use XL2BB to paste the data.

 

[Joe4]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Split data based on serial number and paste beside - OzGrid Free Excel/VBA Help Forum
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.