hm, interesting, I can only give you 50% of the answer, following for the solution!
With this formula, you can map out the urls to columns, but how to get those as rows, I wanna know too.
You could to a Google Sheet workaround, but that seems like an inelegant solution.