Hello, I'm not sure if this is possible, but I am looking for a VBA script that can go through Column A and find the value B04.
When it finds a B04 it will go to the row below it, and if the cell is not blank, then it will copy the cell to the same row as B04, but in the next column over.
Then it would go the the next row down in Column A and see if the cell is not blank again, if it's not then it would copy it to the next column over from the last one.
This would loop until it found a blank cell, at that point it would go back to looking for the next B04 and do it over again until completed.
When it finds a B04 it will go to the row below it, and if the cell is not blank, then it will copy the cell to the same row as B04, but in the next column over.
Then it would go the the next row down in Column A and see if the cell is not blank again, if it's not then it would copy it to the next column over from the last one.
This would loop until it found a blank cell, at that point it would go back to looking for the next B04 and do it over again until completed.