On a data set this small, this isn't going to be super insightful. Meanwhile, in column b, each value occurs in the data set once and once only, with no values appearing more than this. Notice that in Column a, we have 3 distinct values (b, d, e), but only one value that is truly unique (b only occurs once in the entire data set).

Is there a single value that shows up more than others, or is the data uniformly distributed? This can help you quickly identify if the data has any consistency to it or not: The idea behind the Column Distribution feature is to give you a quick glance at the distribution of values in your columns. And while I don't have any empty rows, it would show me that at a glance if I did. However, the cool thing here is that I can very quickly identify that 20% of my data rows in column C are errors. Now, I don't plan on leaving this on all the time.

Which adds 3 new lines to the top of our columns: This one is enabled by going to the View tab and choosing 'Column Quality', resulting in a view that looks like this: (And so far as I know, you can't turn it off - but then why would you want to?) The Column Quality Feature Nothing needs to be set up to enable this by default.

The nice thing about this is that it is always on. (To be fair, you may still get errors after loading, as it is working with a data preview, but still, this will be a BIG help.) See red? You've got potential problems to deal with. This should really help, as the column header will make it obvious that something went wrong. Notice that red bar at the top of column C? That's happening because there is an error in the column! This is SUPER awesome, as we've been teaching for years that you have to scroll down looking for errors each time you change from text to a numeric data type. In its most simplistic form, you'll see that you now get an indicator in the header of each column as shown here: If you're not familiar with these, let's break them down a bit: Data Quality Indicators in Column Headers But I'm super exited to say that I've finally received it in the Insider build of Excel! What are the Column Quality and Distribution Features? If you've worked with Power Query in Power BI, you've seen Column Quality and Distribution features already.

Power query excel 2019