View Single Post
  #5   Report Post  
ratchick
 
Posts: n/a
Default How can I transpose rows to columns in a large worksheet?

Hi again Biff,

I tried it out and my column returned all zeros! I must have done something
wrong. I'll keep trying.

Thanks,
Suzanne

"Biff" wrote:

Hi!

I'll give it a go and let you know if it worked out.


Oh, it'll work! Just do it in "chunks".

Wherever there are empty cells, the formula will return 0.

Biff