Coping from column A to column D

[sybervorld]

I want to extract the data from column A to Column D only the (Name, Category & Country), The formula works only A1 to A9, it doesnot work when i drag down. Some have any idea. I have large data in column A

 

[Scott Huish]

It would help if you could explain what that formula is supposed to do.

 

[Peter_SSs]

Welcome to the MrExcel board!

I don't have such an old Excel version to test but try this.
This is an array formula so should be confirmed with Ctrl+Shift+Enter, not just Enter. If confirmed correctly, Excel will insert {} around the outside of the formula like this.

You can then copy it down.

25 03 01.xlsm
	A	B	C	D
1
2	a			a
3	b
4	c
5	d			d
6	e
7	f			f
8	g
9	h
10
11	j			j
12	k
13	l
14	m			m
15	n
16	o			o
17	p
18
19	r			r
20	s
21	t
22	u			u
23	v
24	w			w
25	x
Extract

Cell Formulas
Range	Formula
D2:D25	D2	=IF(OR(ROW(A2)-LARGE(IF(A$1:A1="",ROW(A$1:A1),0),1)={1,4,6}),A2,"")
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[sybervorld]

It would help if you could explain what that formula is supposed to do.

Regarding XL2BB Add-in is it work in (Libre Office Calc) sheet.

 

[Peter_SSs]

Regarding XL2BB Add-in is it work in (Libre Office Calc) sheet.

Does that mean your main thread question is not a Microsoft Excel question?