Hi everyone, thanks for taking a look.
I have users who need to input values into a sheet such as below:
Table A
And need a dynamic table for the output such as below:
Table B
The output table (Table B) needs to update every time a new row is added to Table A.
I tried many different ideas, (v and hlookup, if statements, index), etc. I need Table B to cycle through columns D-F in Table A and read if there are any values, and if so, create a row in Table B that would populate the amount (Column C, Table B), and the rest of the information.
But I cannot find a way to properly do this, can anyone help? Thank you.
I have users who need to input values into a sheet such as below:
Table A
Date | Donor # | Festival Party | Rennovation Donations | Food Donations | International Relief Donations | Total |
3/1/2023 | 1001011 | Christmas | $101.00 | $51.00 | $152.00 | |
3/2/2023 | 1001012 | Easter | $201.00 | $151.00 | $352.00 | |
3/3/2023 | 1001013 | Easter | $301.00 | $201.00 | $101.00 | $603.00 |
And need a dynamic table for the output such as below:
Table B
Date | Donor | Amount | Purpose | Class |
3/1/2023 | 1001011 | $101.00 | Christmas | Food Donations |
3/1/2023 | 1001011 | $51.00 | Christmas | International Relief Donations |
3/2/2023 | 1001012 | $201.00 | Easter | Rennovation Donations |
3/2/2023 | 1001012 | $150.00 | Easter | Food Donations |
3/3/2023 | 1001013 | $301.00 | Easter | Rennovation Donations |
3/3/2023 | 1001013 | $201.00 | Easter | Food Donations |
3/3/2023 | 1001013 | $101.00 | Easter | International Relief Donations |
The output table (Table B) needs to update every time a new row is added to Table A.
I tried many different ideas, (v and hlookup, if statements, index), etc. I need Table B to cycle through columns D-F in Table A and read if there are any values, and if so, create a row in Table B that would populate the amount (Column C, Table B), and the rest of the information.
But I cannot find a way to properly do this, can anyone help? Thank you.