Hi guys,

I'm trying to sort my data in Excel 2010. I need to convert a set of data in rows (sheet 1) to 7 different groups on sheet 2. The sorting is based om string data in colom K (represented here by numbers for ease).
Group1 gets all rows with value 1 in colom K; Group2 gets all rows with value 2 in colom K; etc

Sheet 1
A (B-J) K
1 text1 (bunch of other cells) 1,4
2 text2 (bunch of other cells) 2,3
3 text3 (bunch of other cells) 1,2
4 text4 (bunch of other cells) 1,7
5 text5 (bunch of other cells) 0

Sheet 2
A B C D etc
Group1 Group2
1 text1 1,4 text2 2,3
2 text3 1,2 text3 1,2
3 text4 1,7

My question for you: what is the best method to do this sorting? I did some searching on the web, but most methods I found are for more 'simpeler 'sorting actions. Should I use pivot tables, VBA or 'cell formulas'?
Who can point me in the right direction?

Thanks!

Schzuki

P.S. As you might have guessed I'm kind of new to this, all help is welcome!