I've attached a sample workbook with data like I have and what I want. I need VBA code to transfer data accordingly.
I'm pretty sure I need a loop that will run through the first column (A) and find each row that is NOT "delivery". If not "delivery" then move col A & B over to Col C & D. Then do the same concept on Column C where each row that is not "beverage". If not "beverage", then move col C&D to E&F.
I know it likely sounds confusing, but I'm fairly certain when you see the sample workbook it will be crystal clear.
Thanks in advance.