Transposing Text Files
<p>I have over 20,000 records that are being exported from a program that look like this:</p>

<pre><code>Parent   : 000691195
CUSTNO   : 115225036-AD
COMPANY  : BROOK FURNITURE RENTAL
ADDRESS1 : 100 N FIELD DR
city     : LAKE FOREST
STATE    : IL
ZIP      : 600452580

Parent   : 000691195
CUSTNO   : 116952265-AD
COMPANY  : BROOK FURNITURE RENTAL
ADDRESS1 : 100 N FIELD DR STE 220
city     : LAKE FOREST
STATE    : IL
ZIP      : 600452598
</code></pre>

<p>I need to transpose them into usable columns and rows, but I have no IDEA how to get it to work from the text file. I have looked at some answers in how to replace the carriage return to a comma but the last piece of data need to NOT have a comma after it to indicate the end of the row and some of the ADDRESS1 fields are empty anyway. </p>

<p>Any help would be appreciated.</p>