How to transform this object?
I know you've already tried proportional editing, but I think you ought to be able to get what you're looking for using it.

Try selecting the bottom edges and scaling it down with proportional editing and linear falloff. You'll then need to use the mouse wheel to adjust the proportional editing size.

If any vertices are slightly off, you can grab them and snap them to the edges of the bottom mesh.