User Name (will be exact duplicates) | Column 1 | Column 2 |
Kevin | 1 | |
Kevin | 2 |
Is it possible to merge/group duplicate rows easily based on a column of duplicate data? Column 1 and 2 will always have one blank row like pictured in the example above, and I need for the resulting format to stay as an .xlsx and viewable in Web. (no macros)