I've exported delivery addresses from Pastel into an Excel Spreadsheet. Each address record that Pastel spat out has a lot of data for each customer that I don't need.
Given the screenshot here, I just need the values on B2, B3, D4, and D5 for each account. I can see there's 7 rows splitting these values for each account. What I need to do is collate these values for capture in CSV format, but I can't work out how to do it.
On Sheet2, I've been trying something like this and copying it, but it's incrementing by 1 row, I need it to increment by 7, can anyone help me to figure out how to do this?