REformatting the data from columns to rows

[kelleybr]

I received this data in rows instead of columns (please see attachment). Can anyone give me an easier solution on how to get the data into rows without having to use the = function on every single cell. I thought excel would eventually find a pattern but it isn't doing it. I have 9000 rows of data, I cannot possibly do this one at a time.