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]
[TD="align: right"]102[/TD]
[TD="align: right"]189[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]102[/TD]
[TD="align: right"]102[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]189[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]189[/TD]
[TD="align: right"]102[/TD]
[/TABLE]
and the result should get of that like below...
[TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 131"]
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