Dear all
[TABLE="width: 500, align: center"]
<tbody>[TR]
[TD]Case number[/TD]
[TD]country[/TD]
[TD]report type[/TD]
[TD]Events/PT term (column D)[/TD]
[/TR]
[TR]
[TD]2223-055684[/TD]
[TD]INDIA[/TD]
[TD]study / interventional study[/TD]
[TD]1) Atrial septal defect (foramen secundum) / Atrial septal defect (s);[/TD]
[/TR]
[TR]
[TD]2222-032943[/TD]
[TD]US[/TD]
[TD]spontaneous / --[/TD]
[TD]1) face redness / Erythema ;
2) felt hot / Feeling hot ;
3) felt faint / Dizziness ;
4) dizziness / Dizziness ;
5) hands and feet weakness / Muscular weakness ;
6) arterial pressure increased to 140/70mmHg / Blood pressure systolic increased ;
7) flushes / Flushing ;
[/TD]
[/TR]
</tbody>[/TABLE]
i want to spilt multiple rows of the column D (Events/PT term) in to separate rows with the rest column contents same and count the unique cases and total rows may be at the top of your output excel. Also highlight rows in alternate color for better readability.
[TABLE="width: 500, align: center"]
<tbody>[TR]
[TD]Case number[/TD]
[TD]country[/TD]
[TD]report type[/TD]
[TD]Events/PT term (column D)[/TD]
[/TR]
[TR]
[TD]2223-055684[/TD]
[TD]INDIA[/TD]
[TD]study / interventional study[/TD]
[TD]1) Atrial septal defect (foramen secundum) / Atrial septal defect (s);[/TD]
[/TR]
[TR]
[TD]2222-032943[/TD]
[TD]US[/TD]
[TD]spontaneous / --[/TD]
[TD]1) face redness / Erythema ;
2) felt hot / Feeling hot ;
3) felt faint / Dizziness ;
4) dizziness / Dizziness ;
5) hands and feet weakness / Muscular weakness ;
6) arterial pressure increased to 140/70mmHg / Blood pressure systolic increased ;
7) flushes / Flushing ;
[/TD]
[/TR]
</tbody>[/TABLE]
i want to spilt multiple rows of the column D (Events/PT term) in to separate rows with the rest column contents same and count the unique cases and total rows may be at the top of your output excel. Also highlight rows in alternate color for better readability.