How do I transform a column to col name and have each account and its balances in one row?

Hi, welcome!

You can use tidyr::spread() function for that.

If you need more specifyc help, please provide a minimal REPRoducible EXample (reprex). A reprex makes it much easier for others to understand your issue and figure out how to help.

If you've never heard of a reprex before, you might want to start by reading this FAQ: