Brandonfromsingapore
New Member
- Joined
- Jan 5, 2012
- Messages
- 38
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!
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!