5 - Populate the Range

 

Populate the range by clicking OK. The range consists of the date span, parameters and codes.

 

 

The range will be set up differently, depending on the data direction selected.

ClosedData in Columns (Codes in Rows)

 

Example

 

Range populated with data in columns.

 

  • Range consists of cells $A1:$D$2
  • Date span shifts the codes one column to the right
  • Parameters are written below the date span
ClosedData in Rows (Codes in Columns)

 

Example

 

Range populated with data in rows.

 

  • Range consists of cells $A$1:$B$3
  • Date span shifts the codes one row below
  • Parameters are written to the right of the date span