arranging data in multiple columns

[Sebsy]

Hi,

So I have a column of data (10,000+ rows) which contain various codes assignedto the individual (Around 60 different codes). These codes situnder 5 different headings, but these headings are not contained within thedata set.

My aim is to insert5 new columns with the row header for each different code type that it sitsunder. I’m just wondering if there is an easy way of accomplishing this, asidefrom sorting and filtering and copying and pasting (which is quite lengthy and laborious)

Thanks inadvance

 

[Sebsy]

Edit: having read this back I think I should be clearer. Each row has 1 of a possible 60 codes assigned to it.