Microsoft Office Tutorials and References
In Depth Information
Figure 16-16: The goal is to identify member numbers that are in the resigned members list.
Change vertical data to horizontal data
Figure 16-17 shows a common type of data layout that you might see when importing a file. Each record con-
sists of three consecutive cells in a single column: Name, Department, and Location. The goal is to convert this
data so that each record appears a single row with three columns.