the result would pretty much...
look like the picture he has uploaded.
i guess he was using rise, and not tilt.
Assuming the OP does not correct the camera orientation, yes; but as I noted in the post if he does correct the roll, pitch and yaw, he will get the result:
Mount the camera on tripod. Don't worry about not having all the building in the viewfinder frame at this stage. Just use in-camera level or one of these to ensure the camera is absolutely level - forward-backward and left-right. There is also another aspect regarding avoiding keystoning by ensuring sensor plane is parallel to the building facade (as described in rotation about the z-axis, the yaw) especially for full-frontal shots, but for the purpose of explanation, let's just focus on keeping the verticals from converging. At this stage, if you've set up the camera correctly, all the verticals are truly vertical, parallel to each other and they should not be converging. If not, no amount of shift will correct the converging vertical.
BTW, ensure the tilt is neutral, meaning the line marked by "T" is at the middle of the scale, on TS-E 24LII at neutral tilt, you should be able to lock the tilt with the lock button, if you can't lock it, then adjust until it can be locked.
Now, use the knob on the TS-E 24 that is closer to the lens mount to SHIFT the lens. If the shift direction is left-right as opposed to up-down, use the lever on the lens closest to lens mount to allow the lens to rotate 90 degrees so the shift direction runs up and down.
Now shift using the same knob again - the frame should move up and down as you look through the viewfinder (it's almost like a view out from the glass elevator going up or down). Note that while going up and down, the vertical lines remain vertical. Find the shift increment that will best include the entire building, then press shutter button.