You can try out the below macro. If you are new to macros..

--Set the Security level to low/medium in (Tools|Macro|Security).
--From workbook launch VBE using short-key Alt+F11.
--From menu 'Insert' a module and paste the below code.
--Get back to Workbook.
--Run macro from Tools|Macro|Run <selected macro()

Sub SortandInsert()

Dim lngLastRow As Long, lngRow As Long
lngLastRow = Cells(Rows.Count, "A").End(xlUp).Row

Range("A1").Resize(lngLastRow, 2).Sort _
Key1:=Range("A1"), Order1:=xlAscending, _
Key2:=Range("B1"), Order2:=xlAscending, _
Orientation:=xlTopToBottom

For lngRow = lngLastRow To 2 Step -1
If Range("A" & lngRow) < Range("A" & lngRow - 1) Then _
Rows(lngRow).Insert
Next

End Sub


If this post helps click Yes
---------------
Jacob Skaria


"Pritesh" wrote:

No I can't do that, the data keeps changing, its in thousands of rows having
multiple records which keeps repeating.
--
Regards,
Pritesh


"Mike H" wrote:

Hi,

The simplest way is to filter the data on column A to display manager 1 and
the assigned projects.

Mike

"Pritesh" wrote:

I have huge data containing running project details, wherein I need to
list-out Names of Projects under various Managers. So a manager can have 1 or
2 or 10 projects under him.

Pls suggest me solution/formula based on below output requirement.

Example Input:

A B
1 Mngr1 Proj1
2 Mngr2 Proj3
3 Mngr1 Proj2
4 Mngr1 Proj5
5 Mngr2 Proj4


Example- Reqd Output:

A B
1 Mngr1 Proj1
2 Mngr1 Proj2
3 Mngr1 Proj5
4
5 Mngr2 Proj3
6 Mngr2 Proj4
7


Regards,
Pritesh