VBA If function

[Fazila]

Hi

I need help with a similar thing to what jufglanville has posted. Basically I am trying to find out what subjects students are studying in a year group at the moment my spreadsheet looks like this

abc ar
ms
gp
gg
def en
sc
ma
hi

And so on, however, I need my sheet to look like this

ar ms gp gg en sc ma hi (not in that order particularly)
abc ar ms gp gg
def en sc ma hi

Any help wit this? Formula or vba would be absolutely fantastic.

Thanks

Fazila

 

[Fazila]

Re: VBA If function (similar to jufglanville's post yet different!)

Just bumping this up any help would be greatly appreciated