Normally, this causes the sand to form into various patterns and designs depending on the frequency at which the surface vibrates. To the naked eye it looks as if the sand is simply morphing into these shapes, but viewing this phenomenon in slow motion may relieve what is actually happening.
Here is a video of sand on a vibrating surface