Problem:
Transposing List1 (column A) into successive three-cell rows.
Solution:
Use the OFFSET, ROW, and COLUMN functions as shown in the following formula in cell C2:
=OFFSET($A$2,(ROW()-ROW($C$2)+1)*3-3+COLUMN()-COLUMN($C$2),0)
Copy the formula across to D2 & E2, and then copy all three cells down columns C:E.
Bookmarks