Transpose from Horizontal(with blanks) to Vertical (without blanks)

[Legacy 185509]

He guys I need help transposing cell from sheet2 to sheet1.
Sheet2 has data, it has data in cell C2,E2,G2,I2,K2.... all the way to IM2.
so it is skipping one column every time.
here is the picture of it
it is green cells

image removed, sensitive information

I want to transpose it without space
thank you

 

[Marcelo Branco]

Hi Greg,

Very good explanation about volatile functions.

What is completely new for me is
"...if there are more than 64K dependencies at which point all cells become volatile"

But, i suppose, its a very rare situation, isn't it?

Regards,

M.

 

[Greg Truby]

Oh, it can happen pretty quick if you have tens of thousands of rows. Just a couple of columns with formulas will put you over the limit.

 

[Marcelo Branco]

Oh, it can happen pretty quick if you have tens of thousands of rows. Just a couple of columns with formulas will put you over the limit.

Good to know.
Urrgh...and to avoid if possible...

M.