Changing a 4x1024 spreadsheet into a single column of 4096
Posted by Johnny-C on July 12, 2001 1:35 PM
I have data that are 4 columns wide and 1024 rows long. The data are read left to right, like a book, so that the first data point is A1, the second is B1, so the fifth would be A2, etc. I want to rearrange these data into a single column so that the data from A1 would go to F1, that from B1 would go in F2, that from C1 would go in F3, and so on. Is there a quick way to do this? Thanks.