I have a dataset with 3 columns: accounts, balances and categories. I need to each category a column name and have each account and its balances in one row. The order of the column names will stay the same but the order of the accounts can change. I also thought of using a template with the category columns already created for formatting purposes.
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: