I am importing data into an Excel table and need to rearrange the data. The problem is that the information for one person is brought into Excel on two separate rows, like this:
Last Name, First Name, ID Number
Blood Type, Height, Weight
I want to reorganize this data so that all the info for...