What are the columns and why are there so many of them? The standard approach is to explode into many tables and introduce joins as you said. Why don’t you want joins?
Reference: https://www.hopsworks.ai/post/a-taxonomy-for-data-transforma...
Usually this would be stored in a sparse long form though. So I might be wrong.