Need help to get count of the value

  • Hi Sir,


    I have a data in column A:A which I need to result other sheet


    data is like... [TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 125"]

    [tr]


    [td]

    Product 1

    [/td]


    [td]

    Product 2

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]101[/TD]
    [TD="align: right"]102[/TD]

    [/tr]


    [tr]


    [TD="align: right"]102[/TD]
    [TD="align: right"]189[/TD]

    [/tr]


    [tr]


    [TD="align: right"]101[/TD]
    [TD="align: right"]101[/TD]

    [/tr]


    [tr]


    [TD="align: right"]102[/TD]
    [TD="align: right"]102[/TD]

    [/tr]


    [tr]


    [TD="align: right"]107[/TD]
    [TD="align: right"]101[/TD]

    [/tr]


    [tr]


    [TD="align: right"]101[/TD]
    [TD="align: right"]189[/TD]

    [/tr]


    [tr]


    [TD="align: right"]101[/TD]
    [TD="align: right"]101[/TD]

    [/tr]


    [tr]


    [TD="align: right"]189[/TD]
    [TD="align: right"]102[/TD]

    [/tr]


    [/TABLE]


    and the result should get of that like below...
    [TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 131"]

    [tr]


    [td]

    Data

    [/td]


    [td]

    Product1

    [/td]


    [td]

    Product2

    [/td]


    [/tr]


    [tr]


    [td]

    101

    [/td]


    [td]

    4

    [/td]


    [td]

    3

    [/td]


    [/tr]


    [tr]


    [td]

    102

    [/td]


    [td]

    2

    [/td]


    [td]

    3

    [/td]


    [/tr]


    [tr]


    [td]

    107

    [/td]


    [td]

    1

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    189

    [/td]


    [td]

    1

    [/td]


    [td]

    2

    [/td]


    [/tr]


    [/TABLE]


    plz help regarding this query