Hello all,
I am at a bit or a roadblock here and I'm hoping someone can give me some ideas. I am trying to convert 1 line of data into multiple but the amount of of lines output will depend on the contents.

For example the original line will include a persons details, then their families details like partner, children etc. So if they have no family i will only need the 1 line, if they only have a partner then i will need 2 and then i will need a varying amount if they have any children based on the amount of children.

Does anyone have any ideas how i can easily accomplish this with excel? I feel like others may have had to do similar before but i cant find any examples.

Any help would be GREATLY appreciated.

Thanks,
Mike