Transpose periodic description rows to column in txt file import

[sidewz]

Hi , im hoping someone can point me in the right direction on this, Im sure its been done before, but I cannot find the right search phrase to find an answer.

I have a txt file output from a system (pabx).
In that file, it has a header row, and then a bunch of comma delimited lines of info about the object in that header row.
Then another header row, and more data rows about that header object.
The number of data rows varies per header row, depending how much info there is about that object.


What i want to know is how to take the header row, and insert it as column A for the following rows, changing it every time there is a new header row.

Eg.

Report object x

data 1, data2, data3
data1, data2, data3

Report Object Y

data 1, data2, data3
data1, data2, data3​

I want it to become.

X, data1, data2, data3
X, data1, data2, data3
Y, data1, data2, data3
Y, data1, data2, data3​

Sample data.

4-13-2013 4:22 PM - Report for Voice System name: Albert St CM reporting - list usage extens 20001
Announcement
Vector	Vector Number	78	Step	17
4-13-2013 4:22 PM - Data Export
4-13-2013 4:22 PM - Report for Voice System name: Albert St CM reporting - list usage extension 20002
Announcement
Vector	Vector Number	4	Step	6
Vector	Vector Number	18	Step	6
4-13-2013 4:22 PM - Data Export

<tbody>
</tbody>

Thanks in advance.
Dave