The attached worksheet has 20,000+ rows of information that I get daily. I have to remove the cell and it's corresponding cell based on the second cell being empty and shift everything left. Example in Row 2 Attribute1Name has the text 2nd Ring Face Design in it and Attribute1Value is empty I need to delete both Cells and shift the rest of the row to the left. This process needs to do this all the way through the row condensing down to just cells with a value and it's name to the left of it. Then proceed down the worksheet to the last row.
Bookmarks