I'm trying to automate trade uploads from a trade blotter into a certain file upload format. Problem is bloomberg only outputs each trade in total and I need to input it into the Prime Broker system by fund in a different format. Does anyone know how to automate the below with VBA or just setting up a spreadsheeet?

Paste in a trading blotter on a sheet1:

Trade Quantity Price Total Cash Fund 1 Q Fund 2 Q Fund 3 Q
A 15 6.8 102 9 5 1
B 8 42 336 3 3 2
C 3 3 9 2 1 0


On a separate sheet (sheet2), have that pull the data pull into a different format, similar to below:

Fund Trade Quantity Price Total Cash
1 A 9 6.8 61.2
1 B 3 42 126
1 C 2 3 6
2 A 5 6.8 34
2 B 3 42 126
2 C 1 3 3
3 A 1 6.8 6.8
3 B 2 42 84