» Transposing a Column into Successive Rows of a Specified Length
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
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:
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Investing for Dummies, Third Edition
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Adventure Capitalist: The Ultimate Road Trip
- Business Plans Kit for Dummies (With CD-ROM)
No comments have been submitted.
