Help auto sorting a sheet

[Viperlx]

So I am trying to sort and combine columns within a sheet.
<table border="0" cellpadding="0" cellspacing="0" width="1873"><tbody><tr height="20"><td class="xl65" style="height:15.0pt; width:65pt" align="right" height="20" width="87">
</td><td class="xl66" style="width:48pt" width="64">
</td><td class="xl66" style="width:48pt" width="64">
</td><td class="xl66" style="width:48pt" align="right" width="64">
</td><td class="xl66" style="width:48pt" width="64">
</td><td class="xl66" style="width:345pt" width="460">
</td><td class="xl66" style="width:227pt" width="302">
</td><td class="xl66" style="width:48pt" align="right" width="64">
</td><td class="xl66" style="width:48pt" width="64">
</td><td class="xl66" style="width:48pt" width="64">
</td><td class="xl66" style="width:48pt" width="64">
</td><td class="xl66" style="width:48pt" width="64">
</td><td class="xl66" style="width:48pt" align="right" width="64">
</td><td class="xl66" style="width:48pt" width="64">
</td><td class="xl66" style="width:48pt" width="64">
</td><td class="xl66" style="width:48pt" width="64">
</td><td class="xl66" style="width:48pt" align="right" width="64">
</td><td class="xl66" style="width:48pt" width="64">
</td><td class="xl66" style="width:48pt" width="64">
</td> </tr></tbody></table>
Column G will have /42922.xml.pgp in it.
Column P will have /42923.xml.pgp in it.

I can have up to 800 different files in each column, including blanks. Is there anyway to pull just the cells in each column(no blanks), and put them all into one column so it looks like below.

Column A

42922.xml
42923.xml
42924.xml

 

[Viperlx]

bump