macro to combine multiple columns based on ID

OK, I have some very large worksheets and a macro would save me days in this situation.

The raw data outputs a sheet with various columns, column A being the ID field. This is not a unique field and contains duplicates.

For each unique ID, i would like to combine all of the data that is unique to that ID per column.

For example, on the attached sheet the first ID is 1. Going across the columns, column B has 1 set of unique data for 1 ("A"), column C has 1 set ("B"), column D has 1 set ("C"), column E has 2 unique records ("D" for first 1, "E" for second 1), and column F has two unique records ("111" for first and "112" for second). I would like one row outputed on a differrent sheet:
(sep columns)
"1" "A" "B" "C" "D/E" "111/112"

Is this a feasible request or too difficult? I am currently doing this manually and is taking hours as the sheets are 30K rows each :/

Try this macro

Please Login or Register  to view this content.

Open up the VBA editor by hitting ALT F11

Insert a new module by hitting Insert - Module

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007.

Screenupdating = False is worth a try

You might also try

Please Login or Register  to view this content.

with a manual filter/delete at the end.

That isn't working -- it just scrolls "deleteme" across row 1

Sorry - typo

Please Login or Register  to view this content.

see attachment, run macro "test", i think that will be quicker