Fulatin809
New member
- Joined
- Mar 6, 2016
- Messages
- 2
- Reaction score
- 0
- Points
- 0
We have 2 huge different excel [2013] payment lists, around 5000 members of our club members, we need to compare this list with a list, around 1000 rows, of their unpaid month fee.
As you can see on following table, we would like to transpose results, because they can be multiple date presents into the unpaid month fee list.
I have the idea to lookup into unpaid fee list if ID is present copy transposed date to payment list but no idea how to do it.
Thx in advanced
As you can see on following table, we would like to transpose results, because they can be multiple date presents into the unpaid month fee list.
| ID | Name | Paid | Unpaid Date 1 | Unpaid Date 2 | Unpaid Date 3 | Cancellation |
| 116 | JOSH BLACK | 20/08/2013 | ||||
| 118 | KELVIN JONES | 11/07/2013 | 21/01/2013 | 2/05/2013 | 13/07/2015 | |
| 137 | ADAM PETTY | 16/11/2016 | ||||
| 132 | KAREN MONEY | 10/03/2015 | ||||
| 500 | LARENS MOUNTAINS | 20/08/2013 | ||||
| 18 | INGRID LITTLE | 3/02/2017 | ||||
| 141 | NAOMI NICE | 7/10/2015 | ||||
| 176 | KELVIN LOVE | 9/10/2015 |
I have the idea to lookup into unpaid fee list if ID is present copy transposed date to payment list but no idea how to do it.
Thx in advanced