data entry reallignment.

Hi There

I’m looking for a bit of help, can anyone assist!?

I have taken a load of data out of a CSV file from a database and wish to put it into a spreadsheet. The CSV file automatically arranges the data as I have displayed it below but I want to move things about a bit to make it easier to use!

I want to move some data entries organised in a single column into field entries at the top of the spreadsheet and for all their corresponding data values in the adjacent column to align accordingly below. I have contacted Microsoft aobut the issue but they suggest I pay $210/ hour for some telephone advise!!!

Sorry for the rather wordy explanation of the problem, its quite hard to articulate without putting a picture up/having a limited knowledge of excel…. I have a screen shot of it here

\1


Can anyone help me out at all?!

thanks

ben