Hi there,
I have a problem with Excel. I don't use it a lot but I am trying to carry out a seemingly simple task. I may need to get a macro written but you may be able to advise better as I am not very experienced.
I have a table of info as shown below (in sheet one)
ssc.jpg
In sheet two I am looking to organize the first column (items) by the associated label in column 2. Basically I want 5 columns in sheet two with column 1-all A's, column 2 all B's, column 3 all C's etc.
When I have tried to do it I use the IF function but I was left with a zero in the space where a false result is returned.
I hope this makes sense but please just ask and I can send on more info or a detailed Excel sheet to you.
Thanks in advance
James
Bookmarks