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)