asddsaasddas
Board Regular
- Joined
- Mar 23, 2020
- Messages
- 60
- Office Version
- 2016
- 2013
- Platform
- Windows
I have a huge set of raw data from column A to AM with a non fixed number of rows. I want to be able to pick which column to use by their specific name and every row under the column and delete the rest of the columns. For example, in the range from column A to AM, I want it to search for "Employee ID", "Name" and "Salary" and take all the rows under these 3 columns and delete the rest of the columns. Thus i will only be left with 3 different columns and their rows. In addition, I want to be able to BOLD the header of each column, in this case "Employee ID", "Name" and "Salary" would be boded. Any help will be appreciated.