Any help
You could use a macro, but (editorial comment) why use a macro when a formula
will do? Here's one idea.
Import your text file into column A. If you have 40 songs, 5 records of
data per song, then you have 200 records of data. Artist 1 of song 1 is in
cell A1.
In cells B1..E1, write the following formulas:
B1: =INDEX($A:$A,ROW()*5-4)
C1: =INDEX($A:$A,ROW()*5-3)
D1: =INDEX($A:$A,ROW()*5-2)
E1: =INDEX($A:$A,ROW()*5-1)
Copy B1..E1 from rows 1-40.
================================================
"Fred" wrote:
I have the top 40 music charts in a text file
the file is like this
5 rows consisting of
line 1 name of artist
line 2 song
line 3 date
line 4 chart position
line 5 is blank
i need to be able to import the list into excel
like this into 4 columns
name of artist, song, date, chart
Any ideas?
Tia
|