Pivot data

[irajaram]

I am trying to pivot the attached data into a table view for use in AMPL. The data has ~ 2 M rows i.e. 200,000 Home ID's x 10 Facility ID's.  I want to pivot to a table with ~ 200,000 rows ( one for each home ID) with 10 Columns ( one for each facility ID)  the table should have the Distance in it.  Think I have to use the Cross-tab and Transpose tools but not able to get it to work.

[Per]

Hi @irajaram 

Yes, the Cross-tab and Transpose tools take a while to get used to 🙂 Sometimes you just need to experiment a bit. If I understood your question correctly, you just need a single Cross-tab to get the expected result as shown below. I hope it makes sense!

[messi007 · Accepted solution]

@irajaram,

Please see below 🙂

Attached the workflow,

Hope that helps,

Regards,

[irajaram]

Thank you - this is perfect