I'm having trouble visualization what this transformation would look like with a matrix? Is it even possible?

It is essentially a product of 3 matrices: translation by x matrix * rotation matrix * translation by -x matrix. After calculating, final matrix seems to look like a combination of rotation and translation (top-left 2x2 part of the matrix has sin/cos elements like rotation matrix, right-most column has values like in translation matrix).