Converting a database to an XML table in excel

[MikeC83]

Hi,

I'm opening a non-excel file in excel and it formats it into a series of rows/columns. The problem I have is that it doesn't consolidate all related data in the same row, for each new column of data it breaks into a separate row. I'd like to easily roll it all up into a single row.

I've attached a sample file to illustrate. The "Original" sheet is what I'm starting with and the "Final" sheet is what I hope to condense the data into.

[Alf]

Perhaps like this? To test run macro "CondValue"

Alf