The sample you posted appears to have row delimiters in it. If there are no row delimiters at all, and the file looks like this:
Then you'll probably have some problems. If the file looks like this:
And there actually are row delimiters, then the BCP format file trick should work. What you seem to be indicating though, is that you want to essentially rotate the columns and rows. I believe there's an SSIS transformation to do something similar, although if not you can bulk load into a temp table and perform a few INSERT...SELECT FROM... statements to move the data from the temp table into your permanent table pretty easily.