Hi,

I have excel workbook containing information:

Title Leve1; Name
CPO 1 Name1
CPO 2 Name 2
CSA 3 Name 3
CPO Name 4

How can I create separate sheets for titles without having spaces
between rows
For example the worksheet for CPO-s would look like:

Title Leve1; Name
CPO 1 Name1
CPO 2 Name 2
CPO 1 Name 4

Instead of:
Title Leve1; Name
CPO 1 Name1
CPO 2 Name 2

CPO Name 4

I would appreciate your help.

Thank You
FG