Merge Data from Multiple Worksheets with Duplicates

Originally Posted by steve49589

Hello,
I'm looking for an easy way to solve a problem I have. I'm working with someone to teach me a way to do this by converting the information into a MySQL database and process it using PHP, but I'm getting a bit confused an was hoping that I could try a different solution here.

I have a spreadsheet that includes five worksheets (tabs), there is a "Main" worksheet that includes the title, description, function, release date, expiration date, filename, business owner name and author e-mail. These eight columns represent eight properties of a piece of content. The piece of content is always primarily defined by the title.

There are four other properties that are assigned to each piece of content. They are represented in each of the other four worksheets (tabs) in the spreadsheet. These properties can have multiple values and in some cases, a title may not have a property assigned at all.

I'm trying to combine all this data so we can more easily complete a manual migration of this content. I'm going to have a data entry contractor enter the information for each content item.

I've put together an example of what I will have to start with, and an example of the results.

Start with this, looking for this.

Any help would be appreciated!

Steve

Hi,

The only way to do this is with some VBA code. It involves analysing each TITL_NM, and recognising where there are several parameters for each of these in different rows, and concatenate these into a single string so that you can get them all into a single cell.

It's doesn't sound like particularly difficult code, but will probably require three or four subroutines to handle the various tasks of program control, identifying duplicates, concatenating and formatting data, and writing back to the Results sheet.

If it's to be a one off task it'll probably be slightly easier than writing it for doing regularly, with all the bells and whistles and error checking that that may involve.

Hope this helps. Post back if you need any further advice.

Rgds

Richard,
Thanks for the reply. It looks like someone will be able to build me a macro to do this. We'll see how that goes.
Thanks again!
Steve