Is this to replace the burnt xfmr? If yes, then what you need is 110V xfmr with appropriate secondary voltage. Do ensure that:
1) Rating (in VA) of new xfmr is same or higher than burnt one
2) Physical dimensions of new is same as old so that it can be fitted in old slot without having to make mechanical mods. Transformer winding workshops ought to be able to rewind it if you give them the burnt one.
If you want an external step down xfmr to obtain 110V, then buy a 230V to 110V step down xfmr of appropriate rating (the TT label will have a rating like X Watts - so you need a step down that's rated X Watts or higher).
As quad mentioned, it is unfortunately very likely that some additional damages may have happened. I hope it hasn't.