Pivot Table?

[Bobbie]

This is an example of my data

Name ID Source A SA Amt a SA Amt b SA Amt c Source B SB Amt a SB Amt b SB Amt
JAMES 23 1 40 500 1000 10 10 100 75
JOHN 24 10 0 800 1200 4 15 200 80
SUE 25 3 20 1000 700 1 20 300 95
BETTY 26 1 30 2000 2500 10 25 400 110
BOSS 27 3 5000 3000 4000 1 30 500 120


This is what I want it to look like

Name ID Source Amt a Amt b Amt
JAMES 23 1 40 500 100
10 10 100 75
7 1000 350 10
JOHN 24 10 0 800 120
4 15 200 80
SUE 25 3 20 1000 70
1 20 300 95
BETTY 26 1 30 2000 250
10 25 400 110
BOSS 27 3 5000 3000 400
1 30 500 120
6190 9150 1430

What is the best way to tackle this? Some rows may have up to 10 sets of data with 8-10 columns in each set

Thanks