If you only have one set of values (like in your question), then as Christofer Weber states in the comments, you can use the Transpose option for pasting, as per the guide which Christofer linked to.
However, if you have multiple records presented in this way and want to transpose them into a table, it's a little more difficult. So for example you have:
And you want:
You can enter the formula:
into any cell, then drag it across and down as required to populate your new table (in the example above, drag the formula across the 3 cells adjacent to the right and then down 2 rows to leave a table with 4 columns and 3 rows). If you had a different number of values in each record, simple switch out the
4s in the formula for the appropriate number of values per record.
You could also achieve this with some VBA, or by using 3rd party extensions for Excel, many of which provide an easier GUI-driven method to achieve this same result. I wouldn't like to recommend any specific ones as I haven't used them myself though.