No. This doesn't work. I wanted the other way around: from ROW to
SHEET.

The formaula way is too much work. In general I want to transpose 25
to 30 columns of data with each column has about 150 rows of data to
SHEET.

Can someone help me in VBA to do this?

Thanks again.