Hi there,

I have a database of client records which holds information that I need to create individual records for. I have exported it to excel, which gives all the client info in one row but I need to separate this out by "plan" so that the general client info is copied down to each new record - does anyone have any idea as to how I go about this? The number of plans for each client varies.

The attachment shows an example of what I currently have and then what I am trying to achieve - I hope it clarifies the situation.

Many thanks,

Martin