Need a reroute through Missouri

Leaving from the Twin Cities June 9 for a tour. We were planning on hitting the Katy Trail around June 17 at Marthasville, taking it west to Windsor and then heading to Kansas. Problem is about 100 miles of the trail is under water, so it's basically closed. Looking for a reroute that, if possible, will still take us through Columbia to see friends. Any experience out there?