Hello i am trying to join cells, separated by commas( , ) and print the result in another cell. I guess this is what "Textjoin" formula in later version of Excel does but i have to work with 2007 version which doesn't have this command implemented.
Please pay attention to the example below if row is left blank, that means i don't want only commas( ,,,) to be printed in the "Results" cells but rather also left blank.
Same for example for "Results" about the (Suzuki)Cultus row, it doesn't start with a comma like: ,Cultus,1993,GTi
So in other words it should put a comma if "Brand" has not been left empty and it should not put a comma in the end if the next cell that needs to be joined is left empty like: BMW,e30,1988 and not BMW,e30,1998,
An example:
Please pay attention to the example below if row is left blank, that means i don't want only commas( ,,,) to be printed in the "Results" cells but rather also left blank.
Same for example for "Results" about the (Suzuki)Cultus row, it doesn't start with a comma like: ,Cultus,1993,GTi
So in other words it should put a comma if "Brand" has not been left empty and it should not put a comma in the end if the next cell that needs to be joined is left empty like: BMW,e30,1988 and not BMW,e30,1998,
An example:
| Brand | Model | Year | Version | Results |
| Suzuki | Swift | 1993 | GTi | Suzuki,Swift,1993,GTi |
| Cultus | 1993 | GTi | Cultus,1993,GTi | |
| BMW | e30 | 1988 | BMW,e30,1988 | |
| Toyota | Corolla | 1988 | Vvti | Toyota,Corolla,1988,Vvti |
