Many Walgreens stores carry turmeric in capsules, like this, in the supplement section.
I'm sure you could order some online, too. Either in pills or powdered form. Another powdered product.
I haven't tried any of those products. They're just examples. I love cooking with turmeric, personally. I just pour it in when I make Indian dals and sabjis. But yes, finding it fresh is another story.
Edit: Amazon apparently has everything. Whole turmeric root is available from multiple sellers.