Find first line FOLLOWING a sequence of matches

[Subhan Michael Tindall]

Table like this: (abbreviated)
|a|b|c|
|a|d|e|
|a|z||
|m|b|c|
|m|c|d|
|ab|c|d|
First col is relevant (actual table is MUCH bigger)

I'm looking  to write a macro to convert this table (on an occasionally 
recurring basis)
To something like:
,* a
|a|b|c|
|a|d|e|
|a|z||
,* m
|m|b|c|
|m|c|d|
,* ab
|ab|c|d|

The entries in first column are always strings of characters, no internal 
whitespace
Looking for a way to search for the LAST match for a given element
With that I should be able to macro-ize my keystrokes and save some time, or 
better yet come up with something to fully process the file

EG:
Insert ,* a header
Search for a in column 1
Find the last a in the block
Move down a line
Copy m & insert ,* m header
Search for m in column 1
<repeat>

Thousands of lines, hundreds of blocks, don't make me export this to excel and 
do it there!





This message is intended for the sole use of the individual and entity to which 
it is addressed and may contain information that is privileged, confidential 
and exempt from disclosure under applicable law. If you are not the intended 
addressee, nor authorized to receive for the intended addressee, you are hereby 
notified that you may not use, copy, disclose or distribute to anyone the 
message or any information contained in the message. If you have received this 
message in error, please immediately advise the sender by reply email and 
delete the message.  Thank you.