The dashboard has room for sixteen sensors, but the trial only supplied a two-row, three-column grid. Pad the view to the fixed shape without replacing the real zero in the source data.

In A2:C3 enter 12, 0 and 9 on the first row, then 7, 6 and 4 on the second. Keep E2:H5 empty so the expanded array can spill.

A two-by-three sensor grid contains six numeric readings including a zero.

Example input. Zero is a recorded reading.

In E2, enter =EXPAND(A2:C3,4,4,"—"). The first size is the row count, and the second is the column count. The dash marks each added position.

A four-by-four result retains the source block and marks the remaining ten positions with a dash.

Example output. The dash labels a position that EXPAND added.

Check that F2 still contains the numeric zero. The added fourth column and bottom two rows account for ten padded slots. If a later calculation uses the grid, make sure its handling of the text markers matches the report’s rules.

Microsoft’s EXPAND reference.