Can you show me how to convert sheet A to sheet B format?

In sheet B, I want to give a space for every Sales Person and do not
repeat their id / names. I also will need to give a space for each
region within each sales person. I appreciate your help.

sheet A
Sales Person ID Sales Person Name customer type region
1100813 John a1 1
1100813 John a2 1
1100813 John a3 1
1100813 John a4 1
1100813 John a5 1
1100813 John b1 2
1100813 John b2 2
1100813 John b3 2
1100813 John c1 3
1100813 John c2 3
1100813 John d1 4
1100813 John d2 4
1100813 John d3 4
1100813 John d4 4
1102312 Amy a1 1
1102312 Amy a2 1
1102312 Amy a3 1
1102312 Amy a4 1
1102312 Amy a5 1
1102312 Amy b1 2
1102312 Amy b2 2
1102312 Amy b3 2
1102312 Amy c1 3
1102312 Amy c2 3
1102312 Amy d1 4
1102312 Amy d2 4
1102312 Amy d3 4
1102312 Amy d4 4
1102367 Todd a1 1
1102367 Todd a2 1
1102367 Todd a3 1
1102367 Todd a4 1
1102367 Todd a5 1
1102367 Todd b1 2
1102367 Todd b2 2
1102367 Todd b3 2
1102367 Todd c1 3
1102367 Todd c2 3
1102367 Todd d1 4
1102367 Todd d2 4
1102367 Todd d3 4
1102367 Todd d4 4



sheet B

Sales Person ID Sales Person Name customer type region
1100813 John a1 1
a2 1
a3 1
a4 1
a5 1

b1 2
b2 2
b3 2

c1 3
c2 3

d1 4
d2 4
d3 4
d4 4

1102312 Amy a1 1
a2 1
a3 1
a4 1
a5 1

b1 2
b2 2
b3 2

c1 3
c2 3

d1 4
d2 4
d3 4
d4 4

1102367 Todd a1 1
a2 1
a3 1
a4 1
a5 1

b1 2
b2 2
b3 2

c1 3
c2 3

d1 4
d2 4
d3 4
d4 4

....
....
....