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.
Solved! Go to Solution.
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!
Thank you - this is perfect