Lieke
08-27-2008, 07:31 AM
Hi,
Can anyone help me with the following problem? I have data in Excel that are organized in columns of 48 rows each (so column A contains the data in 48 rows, the same goes for column B, C etc etc). But now I need to have my data in one column, so that every 48 cells of each column end up in column A, in the right order (so that A49-A96 contains data from B01-B48, and A97-A144 contains the data from C01-C48 etc).
Can I somehow solve this with VBA?
Thanks in advance!
Can anyone help me with the following problem? I have data in Excel that are organized in columns of 48 rows each (so column A contains the data in 48 rows, the same goes for column B, C etc etc). But now I need to have my data in one column, so that every 48 cells of each column end up in column A, in the right order (so that A49-A96 contains data from B01-B48, and A97-A144 contains the data from C01-C48 etc).
Can I somehow solve this with VBA?
Thanks in advance!