Selected Answer

You may like to try the formula given below in D2 of your worksheet.

`=INDIRECT(ADDRESS((ROW()-2)*3+2+COLUMN()-4,1))`

Copy it from D2 to E2:F2 and down as far as you have data in column A. Note that the result in columns D:F will have fewer rows than the original data.

You can modify the formula to copy data from a column other than column A. The final "1))" in the formula specifies column A. If your data are elsewhere, just chnage the column number. For example, *=INDIRECT(ADDRESS((ROW()-2)*3+2+COLUMN()-4,8))* would copy data from column H, i.e. column 8.

The number 2 appears twice in the formula. In each case it specifies that the first data in the source column are in row 2. You can change the start row but please make sure that you paste the formula in the same row in which the original data start before you copy it down and across.

The "-4" in the formula specifies column D as the first column for the result. You can specify any other column to start off from but make sure that the other two are adjacent.

Finally, the "3" in the formula specifies that each third item will be in the same column or, put differently, that there are 3 result columns. The same formula would work with fewer or more columns.