I am reaching out to request your expertise in creating an Excel macro to streamline a task I frequently encounter. Specifically, I need to delete all rows that are highlighted in yellow and then transpose the data to their respective fields. (Blue area)
I have a spreadsheet with data, and certain rows are highlighted in yellow to indicate that they need to be deleted (" Manage Columns" and 2nd "apn". Manually deleting these rows and then transposing the data is becoming time-consuming and error-prone, so I believe automating this process with a macro would greatly improve efficiency.
After data has been cleaned we then need to transpose data as you see the data in blue.
Bookmarks