Create and populate tables

Plan the placement of data in the workbook, on the sheet, in the table, because it expects a EXCEL. It seems that the developers EXCEL well, you know the typical challenges faced by users and created an environment that working in it is really comfortable, but only when you follow some simple rules.

we will Create a table consisting of only non-repeating rows.

Instead of having to enter duplicate data in the table often leave a blank cell. The presence of empty cells in the table difficult to use filters, sorting and building Pivot tables. Fill the blank cells with values from the upstream cells.

IN EXCEL there are several ways to quickly fill cells with values from adjacent ranges.