=SORT (UNIQUE (D3:D13)) Figure E If you’re still using an earlier version, use the Advanced Filter feature to create a static, unsorted list of unique values based on natural data.

A super easy way to generate new records from multi-value columns using Excel Power Query Your email has been sent Have a complex Excel problem? Power Query to the rescue! Analyzing data often ...