Need Help Categorizing Data

Hey guys, thanks reading.

I need to keep track of incomes and expenses. I'm using an android app called Toshl to track expense and income inputs on the fly. It can then export the data to Excel. The red mark shows what the exported data table looks like. The green is how I want it to look like.

\1

I would like to create an automatic process that changes the format of the data from how it's exported to how I portrayed above in the picture (the date format also needs to change (for example from 9/16/14 to 16.9), and I need help because I'm simply not that good with excel. *I'm also using Google Sheets for this, hopefully this process can be replicated there too

Any help appreciated, thanks!

Uhg bump. Would really like help with this!

I added one helped column in Column A, which I've highlighted green. Feel free to hide it. The two tables are all automated, so adjust the formulas as needed when you add additional expense/income items. If you aren't familiar with arrays, you don't just hit ENTER after adjusting the formula. You hit CTRL + SHIFT + ENTER. Let me know if this is what you were looking for and/or if you have any questions.

Thank you, this is good! Thanks for the help, will play with it a little and understand what you did.