Unable to see data beyond first row (US Census Data)

[dj2dirk212]

I've pulled a copy of the US census data and its in a format that seems to be all in the first two columns (see image 1). I've been trying to figure out what is causing this and it is not because of starting in row 2.

I am trying to format the data to be aggregated at the zip code level. Does anyone have an idea on how to format the data to be in a similar structure to image 2? 

[Felipe_Ribeir0]

Hi @dj2dirk212 

You can start the import on the line 2, transpose the data and filter the metrics that you wish to see: