I have a range via a database output.
Row 2
B1=123 B2=text B3=text B4=text B5=text (1) text (2) B6=text B7=10/9/08 B8=123 B9=123 B10=text B11=text
My challenge is I need to separate the two (or more) entires in B5 so they can be counted. I'm leaning towards a pivot table but would except filtering also.
In my mind I'd like a methodology of havign a separte row, perferably right below (B for example) where b5=text (2). Some times there are 4, 5 6, entries in B5. In the format of text (1) text (2) text (3) text (4) text (5).
I need a fix within hours.
Start Free Trial
