The basic idea you are after is possible, but it requires using Linked records. You have to create a relationship between the records in Table 1 and the record(s) in Table 2, and this is done with a “Linked record field”.
Based on your screenshot, it sounds like you’ll want your 2nd Table to represent your Page Names. You’ll need a record for each Page Name. Then, back in Table 1, instead of entering a Page Name as text in a text field, you’ll enter it into a “Link to another record” field, as a linked record to that Page Name in the Page Names table.
Doing this will allow you to get summaries of how many times a Page Name is used in Table 1 via Rollup fields or Count fields.
Here’s a simple little demo base to show you the concept – not sure if it actually does what you are looking for or not, but perhaps it will push you in the right direction:
You can copy that base into your own workspace by clicking the “Copy base” button in the top right corner while viewing it – once copied, you will be able to view the formulas and field setups.
Hopefully that helps!