Grouping records on a new sheet.

I

iam_david_lee

Hi

I have a excel sheet with lots of records, i want to go through the
and group them and put it into another sheet. Groups are divided b
empty column. eg:

Code Name
---------------
234 Dave
456 Matt
231 Ross

234 Dave
123 Lee
246 John
555 Kay

Like this i have lot of records in a sheet, I want to go through the
and group them in another sheet. I have to use the empty column t
identify its separate groups.

I need something like this.

Codes Namen
--------------
234, 456, 231 Dave, Matt, Ross

234, 123, 246, 555 Dave, Lee, John, Kay

Can someone please suggest any idea, i am quite new to excel.

Would really appreciate the help.

Thanks

Davi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping records into a new sheet 0
Grouping date in a new sheet 0
Group Highlighting 8
Match Names in columns then copy associated info from 2 sheets 4
Restructuring records into a list 2
VLOOKUP 1
Remove Specific Text - HELP! 6
grouping cells 3

Top