Deleting/Merging Parent rows against child rows.

[Alex9678]

My sheets have hundreds of these instances and im trying to find a better way to accomplish this. After filling in the parent row info (blue line) into the child rows (red line) I can't figure out how to delete the parent rows as they have no other data except for dates which lead to problems down the road for what i'm building.

In summary, i need to delete the parent row after filling in the child rows. Another solution I could use is if i could merge all parents rows one row down into the child rows. Thanks in advance.

[Paul]

Quick way?

1. Select A3:Ax, where x is the last row there is data in columns C, E, etc.
2. Press F5, then click 'Special...'
3. Select 'Blanks', then click OK
4. With the blank cells still selected, type = and then tap the up arrow key and press CTRL+ENTER to fill the date values into the blank cells.
5. Select A3:Ax again and select Copy, then PasteSpecial > Values
6. Select all of your data (columns A:??) and click Sort > Custom Sort
7. Check 'My data has headers' box, then select the Time column next to 'Sort by'. Click OK.
8. Delete all the empty 'parent' rows that should now be at the bottom.
9. Re-sort your data (custom) by the Date & Time columns to put them back in chronological order.

Note: Because your dates are text strings, they're going to sort alphabetically (Friday, Monday, Saturday, Sunday, Thursday, Tuesday, Wednesday). You may want to convert those to actual dates first. You can apply a display format so they appear like they currently do, e.g. 'dddd, m/d/yyyy'.

Could this all be done via macro? Yes.

[MarvinP]

Hey Alex,
Watch the video that does what Paul is showing above at:
https://www.youtube.com/watch?v=iIKqeaFvltQ

Power Query also has this feature and it is called Fill Down.