hi all,
hope someone can help , i beleive it should be simple but cant get formula right ..
i need to concatenate all row cells on left if right cells is empty and continue for rest of sheet
pls find the sample what is needed . thanks
hope someone can help , i beleive it should be simple but cant get formula right ..
i need to concatenate all row cells on left if right cells is empty and continue for rest of sheet
pls find the sample what is needed . thanks
| description | credit | debit | expected result | credit | debit |
| Monday | 100 | 0 | Mondaytest1 | 100 | 0 |
| test1 | |||||
| Tuesday | 50 | 0 | Tuesday | 50 | 0 |
| Wednesday | 80 | 0 | Wednesdaytest2test3test4 | 80 | 0 |
| test2 | |||||
| test3 | |||||
| test4 | |||||
| Thursday | 45 | Thursday | 45 | 0 | |
| Friday | 60 | Friday test 5test 6 tets 7test 8 | 0 | 60 | |
| test 5 | |||||
| test 6 | |||||
| tets 7 | |||||
| test 8 |
