How to fill the blank with the same value as the first row

[AAAbbbnewbie]

Dear Experts, would like to check how should i fill up the blank in Team Name that read the same value as the first. 

Team Name	Agent Name
Team A	A
	B
Team B	C
	D
	E
	F
Team C	G
	H
	I
	J
	K

end result should be as below. 

Team Name	Agent Name
Team A	A
Team A	B
Team B	C
Team B	D
Team B	E
Team B	F
Team C	G
Team C	H
Team C	I
Team C	J
Team C	K

[barritown · Accepted solution]

Hi @AAAbbbnewbie,

In PowerQuery you can right click on the column and choose Fill -> Down.

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian