Microsoft Office Tutorials and References
In Depth Information
Converting a Vertical Range to a Table
Figure 72-2: Five formulas in columns C:G convert the original data into a table.
These formulas assume that the original data begins in cell A1 and that the conversion formulas
begin in row 1. In addition, these formulas assume that each record consists of five rows. If your
data uses fewer or more rows, you need to use fewer or more formulas — one for each row. In
addition, you need to modify the formulas accordingly. For example, if each record consists of
only three rows of data, the formulas are
C1: =INDIRECT(“A” & ROW()*3-2)
D1: =INDIRECT(“A” & ROW()*3-1)
E1: =INDIRECT(“A” & ROW()*3-0)
 
Search JabSto ::




Custom Search