How to use the ability to fill in empty cells with the one above to merge 2 rows into a single row which contains all the required information in that one row.
------------------------------------------------------------------------------------------------------------------------------------------------------
✅- Free check of your Excel Skill Level- https://excel-skills-assessment.com/s...
🏅- Test employee Excel skill levels- https://excel-skills-assessment.com/e...
🏆- Improve you Excel Skill Levels- https://online-excel-training.auditex...
🇿🇦- Our main website- https://www.auditexcel.co.za/blogs/
------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 Combine 2 rows into 1 row of information in Excel
00:24 Fill in the blank cells with the cell above
00:50 Activate the Filter
01:05 Identifying which rows should be removed