1.In data view, select the empty columns you want to fill with values by dragging the mouse over the column headers or selecting a cell range. If you select entire columns, the fill range will be set to the longest data set in the data view.

2.Choose the command Fill Column with Values from the Data Set menu or from the context menu. You can request further help in the dialog box that appears.

See Also

DataSet

Data Set Window and Data View

Calculate Values in Columns