» Transposing a Column into Successive Rows of a Specified Length
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
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.
Book Store:
Recommended Books:
- Marketing Plans
- The Interpretation of Financial Statements
- Special Edition Using Microsoft Access 2002
- Windows XP All-in-One Desk Reference For Dummies
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Flipping Properties: Generate Instant Cash Profits in Real Estate
No comments have been submitted.
