Help me!

[gledister]

Imagine we have these 2 cells like this:
<TABLE style="WIDTH: 281pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=374><COLGROUP><COL style="WIDTH: 281pt; mso-width-source: userset; mso-width-alt: 13677" width=374><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 281pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17 width=374>1 (29) 1 (30) 4 (31) 5 (32) 5 (33) 2 (34) 2 (36) 1 (38)</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17>1 (28) 2 (29) 2 (30) 2 (31) 2 (32) 2 (33) 2 (34) 3 (36) 1 (38)</TD></TR></TBODY></TABLE>

And at the end we need to have:
1 28
3 29
3 30
6 31
7 32
7 33
4 34
5 36
2 38

can someone give me any idea?!

Thanks in advance!

 

[rs2k]

Might just be me, but I can't see any correlation in what you start with and what you are after.

Can you expand a little please,

Colin

 

[Peter_SSs]

Duplicate to http://www.mrexcel.com/forum/showthread.php?t=539516

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per the Posting Rules (especially points 21-23).

Any bumps, clarifications, or follow-ups should be posted back to the linked thread.