I want to create a macro that will search the cells in column B, select the first set of three values in column B and transpose it in Column D1. Then select the next three values in column B and transpose in Column D2., Continue until the first blank cell in Column B. I have tried to attach a photo as well
I appreciate any help/advice. Thanks!

Capture.JPG