Consolidating data

Consolidating data combines data cells from different source areas into one location by using @function operators. For example, you can add each item in a row of figures to the corresponding items in another row of figures. You can also use row or column labels to consolidate areas of equivalent data entered in different row and column orders. As long as the data has identical row or column labels or both, you can combine it and sort the results in any order you specify.

Wordperfect Quattro Pro conso Consolidating data

You can create and edit consolidation settings, and you can add or remove source cells. You can also reuse previous settings as required. If you no longer need a consolidation setting, you can delete it.


To perform consolidations

Wordperfect Quattro Pro btnbacktotopproc Consolidating data
1.
 
Click Tools Wordperfect Quattro Pro onestep Consolidating data Consolidate Wordperfect Quattro Pro onestep Consolidating data New.
2.
 
Click the Range picker Wordperfect Quattro Pro pgx btnpoint Consolidating data in the Source cells box, select the source cells (rows with rows, columns with columns), and click Add.
If you want to specify source cells in a different notebook, click Browse.
3.
 
Click Next, and specify an operator.
4.
 
Click Next.
5.
 
Click the Range picker Wordperfect Quattro Pro pgx btnpoint Consolidating data in the Destination cells box, and select the destination cells.
If you want to match cells by label rather than position, click one or more label options in the Use label from area, and click Next.
6.
 
Enter a consolidation name in the Consolidation name box.

Wordperfect Quattro Pro note Consolidating data

•
 
If the destination area is smaller than the source areas, results are limited to the size of the destination area.
•
 
When the source and destination areas have different dimensions, the Consolidator tool combines equivalent cells when possible. Cells without equivalent dimensions are handled differently depending on the operator.
•
 
You can type labels in the destination cells or leave them blank and follow the label order of the first source. If you click both column and row labels, the Consolidator tool matches column labels first, then matches row labels within columns.

To edit a consolidation setting

Wordperfect Quattro Pro btnbacktotopproc Consolidating data
1.
 
Click Tools Wordperfect Quattro Pro onestep Consolidating data Consolidate Wordperfect Quattro Pro onestep Consolidating data Edit.
2.
 
Choose a consolidation setting from the Consolidations list.
3.
 
Edit the consolidation setting.
4.
 
Click Consolidate.

To add source cells

Wordperfect Quattro Pro btnbacktotopproc Consolidating data
1.
 
Click Tools Wordperfect Quattro Pro onestep Consolidating data Consolidate Wordperfect Quattro Pro onestep Consolidating data Edit.
2.
 
Choose a consolidation setting from the Consolidations list.
3.
 
Click Add.
4.
 
In the Add source cells dialog box, click the Range picker in the Source cells box, and select the source cells.

Wordperfect Quattro Pro note Consolidating data

•
 
Quattro Pro treats each noncontiguous source cell selection as a separate entry. If you select 3D source cells, the Consolidator tool treats the selection on each spreadsheet separately and combines each selection with those on the other sheets.

Wordperfect Quattro Pro tip Consolidating data

•
 
You can select noncontiguous cells by holding down Ctrl and clicking the cells.
•
 
You can selected cells in another notebook by clicking Browse.

To remove source cells

Wordperfect Quattro Pro btnbacktotopproc Consolidating data
1.
 
Click Tools Wordperfect Quattro Pro onestep Consolidating data Consolidate Wordperfect Quattro Pro onestep Consolidating data Edit.
2.
 
Choose a consolidation setting from the Consolidations list.
3.
 
Choose the source to remove from the Source cells list.
4.
 
Click Remove.

To reuse a consolidation setting

Wordperfect Quattro Pro btnbacktotopproc Consolidating data
1.
 
Click Tools Wordperfect Quattro Pro onestep Consolidating data Consolidate Wordperfect Quattro Pro onestep Consolidating data Edit.
2.
 
Choose a consolidation setting from the Consolidations list.
3.
 
Click Consolidate.

Wordperfect Quattro Pro note Consolidating data

•
 
Quattro Pro combines the current contents of the source cells; new results appear in the destination area.

To delete a consolidation setting

Wordperfect Quattro Pro btnbacktotopproc Consolidating data
1.
 
Click Tools Wordperfect Quattro Pro onestep Consolidating data Consolidate Wordperfect Quattro Pro onestep Consolidating data Edit.
2.
 
Choose a consolidation setting from the Consolidations list.
3.
 
Click Delete.

Consolidating data