I want to create a table like:
In other words, I want to create a table with all the columns of a Table1, and in each table, I want to populate the top 100 distinct values of that column. If there are less distinct values, the column will be shorter than the rest of course.
Is that possible? I wouldn't mind to use Excel to finalise the view.