I am currently trying to transpose a large set of data from rows into columns. Each data set is separated by four blank cells. I was wondering if there was a way to do this automatically. I have attached a rough diagram of what I need to accomplish below.
Capture.JPG
Thank you very much!
Bookmarks