Excel table conversion help needed
-2
Here is the current table: I would like it to look like this: As you can see in the original table, some people don't have data (paid up) for the categories of "rent" "late", "utilities", etc. I have tried vlookup and it works okay, but I can't get the data per person without changing the array table per person.
microsoft-excel worksheet-function vlookup
share | improve this question
edited Feb 6 at 3:03
angelofdev
929 1 20
asked Nov 6 '18 at 17:18
...