Create a custom query on the CMS_User system table by going to CMSSiteManager>Development>System Tables>User>Queries.

SELECT DISTINCT UserID, FullName, UserName
FROM View_CONTENT_BlogPost_Joined
	LEFT OUTER JOIN CMS_User ON DocumentCreatedByUserID = UserID

Then add a Repeater with custom query webpart to your page. Select the newly created query. Set the other properties as you wish and create a transformation. Your transformation might be as simple as

<div><a href="/Your/Page/<%# Eval("UserName") %>"><%# Eval("FullName") %></a></div>

Then create another page, add a repeater webpart to it. This one will be configured to display a list of blog posts for that user. The repeater will display CMS.BlogPost and have a where clause something like this

{%"DocumentCreatedByUserID = (SELECT UserID FROM CMS_User WHERE UserName = '" + {?UserName?} + "')"|(handlesqlinjection)false@%}

On your page you just added this repeater to, you will want to go to the Properties>URLs tab and add an alias

/Your/Page/{UserName}

This should get you what you need or very close.