I have monthly datasets excel files. And I want to combine those files into one. I wanted to see the movement of payments of my customer monthly side by side (see sample table)
customer | January | February |
---|---|---|
1 | 1000 | 800 |
2 | 2000 | 1800 |
But I do not know how to make it like that. Please help me, thank you so much.
I tried to merge the monthly datasets but the output is literally merge, like this,
customer | payment | month |
---|---|---|
1 | 1000 | January |
1 | 800. | February |