As regular Excel users know, Excel works best when data is laid out in a classic table format. When set-up like a table we can take advantage of Excels many features, like AutoFilter , Pivot Tables and many more. Unfortunately we cannot always dictate the lay-out of data as it is beyond our control.