I have tried previous helper columns that would allow me to return rows but looking for a nice clean solution. here's what my data looks like.
<tbody>
Ted
DP
dp
dp
bp
Angela
dp
dp
ap
dp
Mike
dp
DP
dp
DP
Scott
PP
lp
dp
dp
Renee
dp
dp
ap
DP
</tbody>
I'm trying to create a new list of...