There is another solution called "Wide Tables".
But it come with a couple of gotchas.
First the good new, you can have up to 30000 columns in a table.
But the bad news is that you're limited to 8019 bytes per row, which means that you need to nulls in many of the columns to be able to squeeze in all the data.
More info on
msdn[
^].
If this doesn't work for you, you need to use solution one.