R
robbiemc
I work for a membership organisation and wish to produce membershi
cards detailing areas of qualification in list format.
The card software is used by dragging and dropping field headers fro
an excel spreadsheet. Originally we planned to list the areas o
qualification vertically but found that most members do not have al
the qualifications and this would result in blank spaces.
The ideal solution would be to merge all the quals into a single cel
that would list them vertically on seperate rows...I have been tol
this is not possible....???
The second solution is to simply list the data usin
CONCATENATE...unfortunately, in doing so we are left with double space
where data is missing. With up to 24 different areas of qualification w
could have big spaces between data on the card.
Wondered if anyone knows of a way to resolve these problems?????
CHEERS.....
Robbi
cards detailing areas of qualification in list format.
The card software is used by dragging and dropping field headers fro
an excel spreadsheet. Originally we planned to list the areas o
qualification vertically but found that most members do not have al
the qualifications and this would result in blank spaces.
The ideal solution would be to merge all the quals into a single cel
that would list them vertically on seperate rows...I have been tol
this is not possible....???
The second solution is to simply list the data usin
CONCATENATE...unfortunately, in doing so we are left with double space
where data is missing. With up to 24 different areas of qualification w
could have big spaces between data on the card.
Wondered if anyone knows of a way to resolve these problems?????
CHEERS.....
Robbi