need help to reorganise a table with 3 columns

[Brandonfromsingapore]

Hello Forum! Good afternoon! May I ask for your help to pivot a table? Or maybe flip it?
Headers are on row 1. 3 cells only, from Cell A1 to C1.
The cell A1 is a header. It says “Student Number”. The cell b1 is also a header. It says “Allowance from Mum”. Cell C1 says “allowance from Dad”.
The student number (eg 773847 and 819322 and 42900 etc etc) are listed on column A, from cell A2 down to A46. This is not fixed and it differs from file to file.
Column B and C are amount (money). So they are numbers/dollars. Example 70, 43, 24 etc etc

Is there a way to flip and pivot this so that I keep column A still showing Student number but column B is for “allowance from mum” and “allowance from dad” (column B is text/words only) and column C is the amounts (numbers/dollars)?

Thank you so so much!

 

[Robert Mika]

Student	Allowance from Mum	Allowance from Dad	Allowance from Mum Allowance from Dad	SUM
1	10	10	Allowance from Mum Allowance from Dad	20
2	20	30	Allowance from Mum Allowance from Dad	50
3	30	20	Allowance from Mum Allowance from Dad	50
4	40	30	Allowance from Mum Allowance from Dad	70
5	50	30	Allowance from Mum Allowance from Dad	80
6	60	30	Allowance from Mum Allowance from Dad	90

<TBODY>
</TBODY>

Would this help

D2 drag down
=IF(ROWS($A1:A$2)>COUNT($B$2:$B$7),"",$B$1&" "&$C$1)
E2 drag down
=IF(ROWS($A$2:A2)>COUNT($B$2:$B$7),"",SUM(B2:C2))
Then create your Pivot table

 

[Brandonfromsingapore]

Hello, thank you. Is there a way to code it into vba? because i am looking for a way to have this done many many times on several files.

thank you.

Student	Allowance from Mum	Allowance from Dad	Allowance from Mum Allowance from Dad	SUM
1	10	10	Allowance from Mum Allowance from Dad	20
2	20	30	Allowance from Mum Allowance from Dad	50
3	30	20	Allowance from Mum Allowance from Dad	50
4	40	30	Allowance from Mum Allowance from Dad	70
5	50	30	Allowance from Mum Allowance from Dad	80
6	60	30	Allowance from Mum Allowance from Dad	90

<tbody>
</tbody>

Would this help

D2 drag down
=IF(ROWS($A1:A$2)>COUNT($B$2:$B$7),"",$B$1&" "&$C$1)
E2 drag down
=IF(ROWS($A$2:A2)>COUNT($B$2:$B$7),"",SUM(B2:C2))
Then create your Pivot table

 

[Robert Mika]

I's sure there is but I can not help.
If you did not get any respond in a day time just bump here or create new topic with "VBA" in the subject.