I have an Excel file that is formatted in a way that is giving me a fit trying to import it. It has a bunch of merged cells that I need to unmerge but the main problem I am having is there is data below lines that I need to keep tied to the line above it (also out of curiosity, why are we unable to attach Excel files?)
Looking at the above picture, you can see that the description is below the catalog number and shifted over a column. How, when I import, can I move that up to the same row as the catalog number? For these particular files, the description is very important to keep due to being government jobs (in this instance, roadway lighting)
The other hurdle is for the catalog number, D-N is merged and for the description, E-N is merged but I assume I could solve that with a simple:
Could someone give a little guidance on how to handle this?
Edit:
I know this will likely be done via looping and finding rows within column E that contain text, then moving them up to be in sync with the catalog but want to make sure that is correct method to use.
Looking at the above picture, you can see that the description is below the catalog number and shifted over a column. How, when I import, can I move that up to the same row as the catalog number? For these particular files, the description is very important to keep due to being government jobs (in this instance, roadway lighting)
The other hurdle is for the catalog number, D-N is merged and for the description, E-N is merged but I assume I could solve that with a simple:
Code:
Range("D:N").Unmerge
Could someone give a little guidance on how to handle this?
Edit:
I know this will likely be done via looping and finding rows within column E that contain text, then moving them up to be in sync with the catalog but want to make sure that is correct method to use.
Attachments
Last edited: