I have data that has in cell a1 the text "business name" then cell a2 contains the actual business name, cell b1 has the text "business genre" then cell b2 contains the actual business genre and so on for address, phone number and contact then cell a6 goes back to "business name" for the next business etc etc. I want to create a macro that transposes the whole sheet so that I end up with 5 columns - column 1 has the Business name, column 2 has the business genre etc etc