Data Mismatch

I have a spreadsheet that I am trying to turn the data from a top down look to a linear look. The data goes top to bottom and I am trying to get it to go left to right.

Here is an example:
Right now the data looks like this.

Prt_Nbr Schd_Dt Schd_Qty
12345678984 7/15/2013 0:00 0
12345678984 7/22/2013 0:00 60
12345678984 7/29/2013 0:00 60
12345678984 8/5/2013 0:00 60


I would like to see it like this

07/15/2013 07/22/2013 07/29/2013 08/5/2013
12345678984 0 60 60 60
12354894987 60 20 60 60


Ill attach some file examples too.

Can this be done?

Hi Agengler11,

try the code below - it worked for me on your raw-data sheet, run the macro from the sheet with the original data.

Please Login or Register  to view this content.

Please click the * below if this helps

JasperD, If I may as a question / favor. You had written the macro for me but I think the people that are sending us the XML file have changed it a bit. Can you look at it for me?

Here is what I do.....

1 Open Excel and click Data (From Other Sources)
2 Choose XML File (See Attached)
3 Run the macro.
4 Get error message. (See Attached)

(The macro does work if I remove the Rows with 0 in the Schd_Qty)

Can you tell me what is wrong?

Macro:

Please Login or Register  to view this content.