Trying to convert multiple columns into one row of data...

Is it possible to take multiple columns of data (with column 'A' having the same value) and convert it to a row based on the value from column 'A'. Without having to cut & paste... For example (wanting the end result to look like the bottom section):

Excel.jpg

Data in the beginning -

1 number 48
1 name Bob
1 test 2
2 number 94
2 name Jane
2 test 8
3 number 97
3 name Joe
3 test 3

Desired end result -

1 number 48 name Bob test 2
2 number 94 name Jane test 8
3 number 97 name Joe test 3