Search results

I am a newbie. I have a spreadsheet structured like this: id.......name......dpt1.........dpt2 001....bob........1/2/11......1/5/11 I need it to be like this id........name......shottype.......date 001.....bob........dpt1...............1/2/11 001.....bob........dpt2...............1/5/11 I have...