We have an excel spreadsheet that we receive from our client that needs to be manually cleaned up in order to be processed by our system.
The cells of E2, E3, E4 and E5 should become columns populating each row of data. Also, Columns A, B, I, J, K & L are not necessary. This is currently a manual process of cleanup. I was hoping that there was some macro type functions that might be able to do this instead.
I have included a sample of what the original spreadsheet (SpreadsheetDownloaded.xls
x) looks like upon receipt as well as how we would like the data to look for import (EndingExcelColumns.xlsx).
I have filled the spaces of the spreadsheet that we do not need with the red diagonal pattern - hopefully it isn't too obnoxious for reading. I thought it would be an easy way to show which parts of the spreadsheet are garbage versus which are needed.
Please let me know if I need to give any more information and thank you in advance for your help/support.