1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

how to map the money to the months ?

i have this table where there is multiple rows of the same clients, with each diffrening in the amount of rent and the date of paying it, the two columns i highlighted in green

https://preview.redd.it/n86nmta1jmtg1.png?width=1200&format=png&auto=webp&s=d72acb8b3d0786e2a0dd2fc5fef921f30dc2b675

what i want to do it to make is to make each client a single row and map the amount of money in months columns, like shown in the image below

https://preview.redd.it/p78w91vajmtg1.png?width=1904&format=png&auto=webp&s=9205db8d5f128a689c4145fcc5c8d3960729d9a2

thank you in advance!

submitted by /u/PurpleDurian7220
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#Excel compatibility
#row zero
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#Excel alternatives