Hi,

Is there a way to custom sort by date?

Custom sort by date.png

Workbook 1 and 2 are done in 2 different offices and they encode their own data's.

Is there a way to combine 2 datas into 1 workbook, but skip spaces in between dates that are blank?

In the photo, there's data on the date 05/11/23 so the left side skips a row. On the date 10/11/23, there are 3 datas, so the right side skips 2 rows and so on.

If not, is there another way to output the same kind of data?

Thank you.