Any help
Enter this in B1 and copy across to F1
=INDEX($A:$A,(ROWS($1:1)-1)*5+COLUMNS($A:B)-1)
You will return zeros to column F because of the blank every 5th row.
Delete column F
Then select B1:E and copy down untill you get zeros
When happy, Copy B:F then EditPasteSpecialValuesOKEsc.
Delete column A
Gord Dibben MS Excel MVP
On Wed, 14 Nov 2007 21:21:38 -0000, "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
|