Lauren, welcome to the wonderful world of ACS data in Tableau. It's ugly.
You can likely do a lot of stuff in Prep to make this more usable, but conceptually you need to pivot the data so that you have a lot fewer columns and a lot more rows. It's been a while since I had to do this, but it was a very manual process for me. Prep should help you automate it.
You'll have to consider exactly what you want to do very carefully (for instance, you'll have to TRIM() the values in Column A to get rid of the embedded indentations). You may very well end up manually copying and pasting data into a new spreadsheet entirely.