



Since they didn’t line up in neat columns, I needed a different method. This left awkward gaps and all I wanted was to quickly delete the gaps and shift contents of remaining cells to the left to sort of “reconstruct” each row without gaps. Basically I removed the parts of a URL column expanded by delimiter (“/”) I didn’t want. This is, of course, after some manipulation.

At one point it resembled something like: Today I was using a CSV export of data in Excel and was just using Excel to reassemble the data.
