Hi,

i was working on a sheet, which contains data from 1st row to some X row.
Data in first row can be only 2 in count,while data in X row can be Y numbers of count. My requirement is to arrange data into single Column, and each row data should be separated by only one single blank cell.
I have a VBA code, which arranges data into a single ROW,which i transpose to Column....But it leaves me with multiple cell in b/w them, however i only need one blank cell.
Attached file for better clarity and with VBA code.