MS Access or Excel Q: Particular rows into a column.

Factual Questions
1

Recently, I downloaded a list of properties for sale, and wanted to import that list into Access to easily sort it. The list was an HTML page format, but I can save it/import it into anything: text, *.xls, Word . . . whatever.

Here’s my problem. I download the HTML, and it saves/imports it into this:




000-100-100-0   Hendrix Jimi                    $100.00
                           100 Voodoo Chile Way
                           Current 2006
(Everything here is in it's own cell:  three rows, three columns of cells)

What I am utterly convinced of is that there is a way to move (through automation) the address and year cells to make the entire tax record fit on one row, in order to more easily manipulate it in either Excel or Access to look like:



000-100-100-0    Hendrix Jimi     $100.00     Voodoo Chile Way    Current 2006
(One row, five columns of cells)

What the heck am I missing? Do I have to cut and paste through 2,000 different records, or can I import through Access or Excel different rows to different fields*? This this is driving me up the wall :mad:

Tripler
I was a Chairborne, PowerPoint Ranger. Now, I must go back for more Jedi training.

2

There are a few different ways to do it, but if this is a one-time deal I would just use the following:

(I’m working with Excel 2003)

  1. Create formulas in col D and E that pick up the values in col B in the two rows below. At this point, every 3rd row looks good.

  2. Select all, copy, paste special - values. At this point, there is no more formulas, just data.

  3. Do an Auto Filter on your list. Select non-blanks in Col A. Copy, paste somewhere else. This eliminates the second/third rows for each record.