Arrange Scattered rows value to underneath appropriate columns heading

Hi Expert,

I am new to the VBA world. However, I am trying to get done one tedious task. Here is the description of problems

I want to bring some scattered rows in data range directly underneath the appropriate columns

here is the description of manual way of doing the same task. Probably it can help you building your logic

1. first, I check for last empty rows in column "M" i.e for country(By pressing CTRL + Down arrow key in column "M") and then i look into the immediate next empty rows where is the date values, usually i found it into next rows but in a different columns. so i copy the range one cell before from date values till last columns in that same row and i bring it back to the original row where it should be indeed.

for example after pressing CTRL+down arrow key in columns "M", If i see date values In next immediate rows "E7". I copied from "C7" or "B7" (one cell before date value cell) ,depending on In which cell the date value is sitting till last columns i.e "N7" and paste it manually to "D6". and I do repeat the same work manually till i aligned all rows to their proper place.

Hope my above description can help you understanding the problems. I am attaching my file also, so you can understand it better.

I really appreciate your help.

Thanks,
Ritesh

Ritesh,
Your explanations are detailed but to follow them and prepare a macro we need a sample of your data.
PCI