Re: Multiple records per row

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Roger,

Thank you for your answer. However, I was not clear in my goal. Referring
to the example I gave, I show the first row (and header) as:

1 2 3
----------------------
a b c
d
----------------------

I want to convert this row into 2 rows:

1 2 3
----------------------
a b c
----------------------
a b d
----------------------

And, for example, again referring the earlier example, I'd like the third
row converted into 3 rows in a similar way as to what I just showed above. I
want to do whatever the solution is to all the rows. Then I can apply the
autofilter, sort, or whatever.
--
Regards, timg.


"Roger Govier" wrote:

Hi

It looks like there are line feeds in the data, and format is et to wrap
text.

Try Find and Replace (Ctrl +H)
Find Char(10)
Replace leave blank

If that doesn't work, in a spare column try
=SUBSTITUTE(A1,Char(10),"")
and see if your
b
b
b
becomes bbb

If so, repeat this for all three columns and copy down, then copy the 3
columns and Paste Special>Values to "fix" the data.
Carry out your filter on this revised set of data.

--
Regards

Roger Govier


"timg" <timg@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A760FD20-175B-4957-8280-A6D24C54C6EA@xxxxxxxxxxxxxxxx
I would like to use the autofilter function on an imported database.
Unfortunately I don't have the ability to alter the database until
after I
import it into Excel. The problem I have is that some of the columns
have
more than one record per excel row. For example:

1 2 3
---------------
a b c
d
---------------
e b g
---------------
a b c
b
b
----------------
s f h
---------------

The '----" denote excel rows. The "1,2,3" denote excel column
headers. Any
ideas on how to proceed?
--
Regards, timg.



.

Relevant Pages

  • Re: Roddick Interview
    ... Roger has more class than that. ... brought up the "piece of cake" remark. ... as referring to the match when he was actually referring to his ... It's a stupid question to begin with and they get it all the time. ...
    (rec.sport.tennis)
  • Re: Roddick Interview
    ... Roger has more class than that. ... I think Roddick is a classy guy too, but in this case, he himself ... brought up the "piece of cake" remark. ... as referring to the match when he was actually referring to his ...
    (rec.sport.tennis)
  • Re: Anti-americanism and the world [OT]
    ... Roger, ... how dumb do you have to be to respond to obvious ... You didn't even change the header. ...
    (rec.models.railroad)
  • DO NOT EVER CROSSPOST TO ALT.USENET.KOOKS
    ... But you would say that, wouldn't you, Roger? ... Hell hath no fury like an imposter scorned. ... See the header. ...
    (rec.music.classical.recordings)
  • Re: Clemens is meat
    ... Does Roger ... have a pair of ball bearings in his hand? ... with geometric logic that there exists a duplicate Clemens clone. ... Pettitte and McNamee were referring to this man when they were ...
    (alt.sports.baseball.ny-yankees)