I guess my questions framing was too complicated 🙂
But here the issue I am trying to figure out.

Let’s say I have two columns. “City” and “Number”.
When working in this spreadsheet I will manually enter Cities and corresponding numbers in each row. There could be multiple rows for a city with different or same numbers.

=============================
Name         |   Number      
=============================
Denver       |   10
-----------------------------
San Diego    |   30
-----------------------------
Denver       |   10
-----------------------------
Denver       |   30

Now after entering, I want to have either a button on the page or run a macro that will generate a list where I want to generate one row for each unique City/Number pair. eg. the above list would generate a new set of columns whichever cell I run it on:

=============================
Name         |   Number      
=============================
Denver       |   10
-----------------------------
San Diego    |   30
-----------------------------
Denver       |   30

Just not sure how do I go about solving this?
Any tips appreciated.