How do I figure out the local and state when filing tax return using transcripts only.

Transcripts from the IRS do not include any type of state or local income or taxes withheld.

If you cannot obtain the W-2 from your employer, then for a fee you can get a complete copy of a W-2 from the Social Security Administration - https://faq.ssa.gov/en-us/Topic/article/KA-02501

You need good records to itemize, and to have on hand if you are challenged by one of the 57,000 new IRS employees.