I have a pool of data, eg. from C1 to S100, and there is some empty in
between column and rows. I have to transfer these data into another
worksheet which only have 50 rows available. How can I do it?