Importing XML issue

[allin1joe]

I am trying to import an XML of a project plan into Excel. One row of data in the XML file is showing up in multiple rows in Excel. For example, the task name is in row 2, the start date in row 3 and end date in row 4. How do I get this to appear in one line in Excel?

Thanks!

Joe

BTW -- Here's a snipet of the XML format:

<Task><UID>1</UID><ID>1</ID><Name>Project Initiation</Name><Type>0</Type><IsNull>0</IsNull><CreateDate>2011-03-23T06:51:42</CreateDate><WBS>1</WBS><OutlineNumber>1</OutlineNumber><OutlineLevel>1</OutlineLevel><Priority>500</Priority><Start>2011-03-14T08:00:00</Start><Finish>2011-04-15T17:00:00</Finish>

I used the XML Source pane to drag Name, Start and Finish into the workbook.

[Leith Ross]

Hello allin1joe,

Welcome to the Forum!

You should post your workbook. Seeing the layout, formatting, formulae, and any VBA code, will guarantee you a working solution. A lot of time will also be saved by eliminating guesswork.

[allin1joe]

I can attach the XLS, but I can't attach the XML so it probably doesn't make sense for me to post it. It looks like it's the XML file that's causing the issue. I'm trying out a new Open Source program and I figured out what I need to do in that tool to "corrupt" the XML. So, I'm going to contact the creator of that software to see if they can fix it.

Thanks, and I look forward to posting a "useful" question next time .