AnsweredAssumed Answered

Remove Null from database

Question asked by virgiltu on Sep 17, 2010
Latest reply on Sep 20, 2010 by virgiltu
I am taking data from an access database. However there are some NULL spaces in some of the tables. I need the entire tables with no nulls.
so i found the remove null function but i can only change the null to an empty character or the null word. However when it output i still have the spaces between. Is there a way to remove them. Images 1 is what i was able to get but i am looking to get an output as in image 2. Note image 2 is just paint edited i was not really able to get that result.

Thank you
Image
Image

Attachments

Outcomes