Hi, I have an excel sheet that contains a column of data I need to transpose into several rows. The issue now is that i need parts of it, every 14th row i need a set of 11 rows these 11 rows is then transposed to a new sheet where every set gets a new row. It's a pain in the *** to do it manually.

So far I'm using =TRANSPOSE(Raw!K87:K98)
how can i increment the cell numbers by 14 automatically?

I'll be grateful for any reply, thanks!


EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.eggheadcafe.com/tutorials...vices-usi.aspx