Help rebuilding table previously built on another platform

Hey. Thanks in advance. I've recently taken over some projects from another department of ours. As most of this was left in disarray I'm trying to salvage and integrate as much of the underlying data...