Excel TRANSPOSE
 

Does anyone know how to take 7 rows/20 columns and place into a single column
as the example I have here???? This information is uploaded into our
database and while I can transpose the rows to columns, I then have to take
the 7 rows and paste them into a single column. It would be great to setup a
macro or VB for this one, but I don't know how...??? Please help...

Thanks!

Example of what I need:

090109
100000.00434
5.00
067

[cs3tm]

090109
100000.00422
15.00
067

[cs3tm]

090109
100000.00612
5.00
067

[cs3tm]

090109
100000.00731
15.00
067

[cs3tm]

090109
100000.00356
5.00
067

[cs3tm]