Join Dennis Taylor for an in-depth discussion in this video Fill in missing title information, part of Excel 2016: Cleaning Up Your Data.
- [Narrator] The first worksheet in our Chapter 6 file…is called MissingTitles.…And as we look at Column A,…and as I start to scroll down the list,…I think you quickly pick up on the idea…that every time we see a new department name here…that name applies not just to the person to the right,…but also the names right below it,…until we see another heading out there in Column A.…This makes for good readability,…and also when we print this it might be fine.…However, some of the departments…might have many, many names…and you don't see a department entry for a long time.…Anyway, whether you regard this as good or bad,…this list has arrived to you in this form,…and your concern is if you want to work with the list,…and for example sort by Compensation or Employee Name,…we're going to lose track of which person…is in each department.…
This is a contiguous list.…If you click on a single cell, for example in Column B,…double click the bottom edge or press Control + Down Arrow.…We see it goes down to Row 742.…I'll double click the top edge.…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Moving and inserting rows and columns of data with a simple drag
- Replacing data at the character level
- Converting dates with text functions
- Converting text data to values
- Using the CONCAT and TEXTJOIN functions to combine data
- Splitting data into columns via the Text to Columns feature
- Using Flash Fill for faster combining and splitting
- Checking and correcting spelling mistakes