How to add 3 rows with every change?

G

graydon

Hi
I have a database where there are only 2 types of information on each row
within the 'P' column ('PE' and 'IP')
I was wondering if somebody might show me how I could add 3 rows eachtime
the next level changes (i.e from IP to PE) and (PE to IP)
the blocks of continuity vary, there could be 30 IP's then 2 PE's and then 7
IP's etc.
I just need 3 added rows each time they change from one to the other
Thanks
G
 
Top