Transpose

[Niklas Nilsson]

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/tutorial...a-6dafb17b6d74/wcf-workflow-services-usi.aspx

 

[Pete_UK]

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

 

[Herbert Seidenberg]

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