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

Are you saying that you have a column of data in blocks that occupy 14
rows per block, but only 11 of these contain data and there are 3
blank rows at the end of each block?

If so, is your data in column K of the Raw sheet (and where does it
start)? Do you want the transposed data to start in A1 of Sheet2 and
to go across to K1 and then down?

Pete

On Sep 19, 1:28*pm, Niklas Nilsson wrote:
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 Exchangehttp://www.eggheadcafe.com/tutorials/aspnet/3d49fa0d-a120-4977-842a-6...

Excel 2007 Tables
Transpose by blocks.
http://www.mediafire.com/file/ymzdxom1wtz/09_19_09.xlsx