Duplicate rows based on condition

I am working on providing reports on data. However, the data is not clean and has errors. In the following spreadsheet, every ID has to have one Book ID associated with it. However, multiple entries have also been recorded. I am trying to identify rows with multiple entries of IDs and then duplicate the row and record just one ID. For eg, If there is an ID with two Book-IDs, then that row has to be duplicated once and the Book ID field should have only the second Book-ID. I have provided sample results as well.

I tried writing a macro but it does not seem to be working out. Plz help.

Thanks,
Booo

Hi booo,

Does this do what you are looking for? I've assumed that the IDs will always be seperated with commas.

Please Login or Register  to view this content.

Kyle, That was just amazing. But I am completely new to Macros and would be very grateful if you could exlpain the code, atleast briefly. All the commands are completely foreign to me.

Many Thanks,
Booo

I've added a lot of notes to the code, but if not clear you might be better off reading up on loops and arrays as you will use them a lot, if you've got any specific questions though let me know

Please Login or Register  to view this content.

Kyle,

I am extremely thankful for the effort. You are awesome.

Booo

There is only one small problem. The sample data that I have provided has just 3 columns but the real time data I deal with has about 100 columns.

I;m sure that there is an easier way to insert data.

Can you upload a sample workbook with the data laid out as it is in your actual workbook?

I'll have a look at it and come back to you.