How to change the format?

[Tim]

I have some data from a SQL database I have put into an excel spreadsheet,
this has produced four columns of data. In the coloumn B is a reference
number and in coloumn C is the name the field and in coloumn D is the data.
Now there can be upto 12 rows of information for the same ref. number with
different field names and their relevant data. I need to do is to reformat
the page so that the so that the field names in coloumn C go across the
page, but I don't have a clue on how to do this, any suggestions?

Tim

 

[AltaEgo]

Hi Tim,

Ito sounds like you want to want to transpose your data. For example from:

123, name, Tom
123, Date of Birth, 01/10/1988
123, address, somewhere

to

123, 123, 123
name, date of birth, address
Tom, 01/10/1988, somewhere



If this is the case, select all of your data

Click- Edit, Copy
Move your cursor to a new location outside the selected area
click - Paste Special, check 'Transpose', click OK

The above is for XL2003. If you use 2007,

http://office.microsoft.com/en-us/excel/HP102245021033.aspx


If this is not what you want, you may need to reply with a layout sample
sample similar to the above.