need help for Arrangement record, Vertical sort VS horizon sort

Title

need help for Arrangement record, Vertical sort VS horizon sort

Post

Hi eveyone,

I m using FMP pro9 with win vista

I have a database with 5 records in Table 1:

1)

|ID| Name| Price|

|1  | A       | 1     |

|2  | C      |  2     |

|1  | B      |  2     |

|2  | A      |  1     |

|1  | C     |  3     |

If I make a report layout with sort by ID and by Price I will have report shown in Table 2:

2)

|ID| Name| Price|

|1  |  A        | 1     |

|    |   B       |  2     |

|    |   C       |  3     |

|2  |   A       |  1     |

|    |   C       |  2     |

Now I want to make another report show the same information in Table 1 and 2, but in different way as in Table 3:

3)

-------------------------------------------

|ID       | Name1   | Name2  |  Name3   |

---------------------------------------------------|

|1         |   A            |    B          |    C            |

|           |Price1=1 | Price2=2|  Price3=3|

|--------------------------------------------------|

|2        | A               |    C         |                    |

|          |Price1=1  | Price2=2|                  |

|--------------------------------------------------|

Can anyone tell me if possible that I can have the report/layout for 3) and how?
Thank so much.