Hi all

I have spent some time searching and trying, but I haven't been able to solve my problem yet. Hope some can help me.

I have an Excel workbook containg several sheets that imports data from XML. One of the sheets contain data like this:
Column A - Column B - Column C
1000 - 1 - Data (text)
1000 - 2 - Data (text)
1000 - 3 - Data (text)
1001 - 1 - Data (text)
1002 - 1 - (empty)
1003 - 1 - Data (text)
1003 - 2 - Data (text)

The first row (A) is a uniqe identifier from a database, the second column (B) contains an index number to show how many records there is in the database for this uniqe identifier and finally column three (C) contains the actual data.

I need to combine the data so that I get all comments on the same row, prefferably in separate columns.

Once this is done I will use vlookup to take the cell content and put it on another worksheet before importing to another database.

All help and tips appriciated.

Best regards
Lars-Inge