How to add 3 rows with every change?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Scrabble Value calculation for Welsh words 0
Unable To Connect To Internet - IP Address Conflict 6
If 3 If's, then sum 13
add a row after every unique number 5
How can I count deviations between two rows? 3
Add a row and totals based on changing cell values 2
How to count rows with changing data 1

Back
Top