Need formula to Copy data in blank cells

[motivationalistic]

Hi , I am pasting a sample data below from my spreadsheet. Is there any formula to fill the blank cells of Column A, B & C with values preceding the blank cells? Thanks

Name	Dob	Id#	Co.	Transaction Date	Column F	Column G
Willie Fulmore	03/08/1957	2484	Data 1
			Data 1	02/15/17	886348	375
			Data 1	02/15/17	131616	34
			Data 1	02/15/17	680166	100
			Data 1	02/15/17	886093	48
Mark Smith	06/10/1978	2258	Data 4
			Data 4	10/23/17	307021	95
Joshua Anthony	11/25/1999	2458	Data 1
			Data 1	09/05/17	965032	106
			Data 1	09/05/17	917207	500
			Data 1	09/05/17	34538	50
			Data 1	09/05/17	610821	100
			Data 1	09/05/17	467577	48
David Acero	09/05/1988	2422	Data 3
			Data 3	06/19/17	654908	106
			Data 3	06/19/17	269226	34
			Data 3	06/19/17	117786	25
			Data 3	06/19/17	676664	48
			Data 3	08/14/17	810457	106
			Data 3	08/14/17	71237	100
			Data 3	08/14/17	5653440	48
Morris Ron	12/01/1980	2188	Data 1
			Data 1	05/08/17	5571929	150
			Data 1	05/08/17	4565606	100
			Data 1	05/08/17	1372945	48
Steven Nygaard	01/17/1992	2463	Data 1
			Data 1	03/09/17	2490634	-21.65
			Data 1	03/16/17	2976255	-21.65
			Data 1	08/07/17	3868910	46
			Data 1	09/13/17	2798865	46
Selina Gallo	12/23/1963	2127	Data 2
			Data 2	03/23/17	2459967	890
Joseph Harris	04/06/1991	2259	Data 2
			Data 2	02/01/17	3903125	48
			Data 2	03/16/17	9934616	1875
			Data 2	03/16/17	4825191	125
			Data 2	03/16/17	8635715	34
			Data 2	03/29/17	6651663	1875
			Data 2	03/29/17	9338192	125
			Data 2	04/05/17	279961	1875
			Data 2	04/05/17	6310201	125
			Data 2	04/12/17	1475661	1875
			Data 2	04/12/17	5714878	625
			Data 2	04/26/17	7417904	106
			Data 2	04/26/17	5619306	2500
			Data 2	04/26/17	1971509	70
			Data 2	04/26/17	4237123	48
			Data 2	05/15/17	2180476	48
Joan Kiszka	09/11/1964	2639	Data 3
			Data 3	07/01/17	532400	185
			Data 3	07/01/17	4913493	126
Sandra Buchanan	11/14/1978	2698	Data 4
			Data 4	10/01/17	7075254	252
			Data 4	10/01/17	199241	252
			Data 4	10/01/17	2601957	252
			Data 4	10/01/17	7793206	252
			Data 4	10/01/17	6191798	252
			Data 4	10/01/17	2283015	252
			Data 4	10/01/17	9169277	252
			Data 4	10/01/17	8829888	252
			Data 4	10/01/17	7189950	252
			Data 4	10/01/17	5023107	252

 

[Joe4]

Yes.
See here for instructions: How to fill empty cells with 0, with value above/below in Excel

 

[motivationalistic]

Perfect! Thank you very much Joe

 

[Joe4]

You are welcome.
Glad I was able to help!