I have a huge excel file which has the details of many people. My job is to check each person's details individually and standardise their data to all the rows (For example, A person whose name is in many identity numbers, and their birthdate or the address or any personal it may be, is given only in one row, I've to copy paste the data to all the rows wherever this person's name is. Likewise, I have to do the same to other columns). For this, what I'm doing now is using the auto filter option to filter the person's first name one by one and checking their data (i.e. I first filter the first name, standardise the details and uncheck that name in auto filter menu and check the next name to work on it. I do like this for every name). As I have thousands of people's data, it takes so much time to check and uncheck the names in auto filter menu for each and every name. I don't have the knowledge of excel VBA or power query. So I don't know how to create a macro for this. I don't even know if this could be done through a macro. Also, I didn't find any solution for this particular problem in Google as far as I searched. My doubts:
- Can we simplify the checking and unchecking process in auto filter menu to move to the next name in any way? How to filter the First name column easily without using the check&uncheck option in the filter menu? Like adding a previous and next button which does job with a click instead of manually checking and unchecking the names?
- I need to make sure that all the details of every person is same on all the columns after the Last name column. Is there any way to do that instead of copy pasting the data from one row to all the other rows? I'm a beginner in excel. So, please help me on this. I'm attaching the example pictures of the real file that I'm working on here --> Sample 1; Sample 2; Sample 3 Please note that I've hidden the columns which are not needed to be standardised on person basis. Hope I’ve explained my doubts properly. Thanks in advance! ps: I'm using Excel 2016.