eliminate the empty content

[gigiyi]

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 12pt" border=1 cellSpacing=0 cellPadding=0><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD>Shirley</TD><TD style="TEXT-ALIGN: right">100</TD><TD> </TD><TD> </TD><TD> </TD><TD>Shirley</TD><TD style="TEXT-ALIGN: right">100</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD>Benjama</TD><TD style="TEXT-ALIGN: right">57</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD>Kaden</TD><TD style="TEXT-ALIGN: right">69</TD><TD> </TD><TD> </TD><TD> </TD><TD>Benjama</TD><TD style="TEXT-ALIGN: right">57</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD>Lawrence</TD><TD style="TEXT-ALIGN: right">33</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD>Angela</TD><TD style="TEXT-ALIGN: right">75</TD><TD> </TD><TD> </TD><TD> </TD><TD>Kaden</TD><TD style="TEXT-ALIGN: right">69</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>Lawrence</TD><TD style="TEXT-ALIGN: right">33</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>Angela</TD><TD style="TEXT-ALIGN: right">75</TD></TR></TBODY></TABLE>
hi experts,
Can someone help me to consolidate the data from (F1 - G9) to look like as (A1 - B5)?

Thanks in advance.

gigi

 

[wigi]

Hi

select F1:G9. Push the F5 button, choose Special... > Blanks > OK.
Right-click the activecell and delete. Choose "Shift cells up".

 

[T. Valko]

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 12pt; FONT-FAMILY: Calibri,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD>Shirley</TD><TD style="TEXT-ALIGN: right">100</TD><TD></TD><TD></TD><TD></TD><TD>Shirley</TD><TD style="TEXT-ALIGN: right">100</TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD>Benjama</TD><TD style="TEXT-ALIGN: right">57</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD>Kaden</TD><TD style="TEXT-ALIGN: right">69</TD><TD></TD><TD></TD><TD></TD><TD>Benjama</TD><TD style="TEXT-ALIGN: right">57</TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD>Lawrence</TD><TD style="TEXT-ALIGN: right">33</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD>Angela</TD><TD style="TEXT-ALIGN: right">75</TD><TD></TD><TD></TD><TD></TD><TD>Kaden</TD><TD style="TEXT-ALIGN: right">69</TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD>Lawrence</TD><TD style="TEXT-ALIGN: right">33</TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD>Angela</TD><TD style="TEXT-ALIGN: right">75</TD></TR></TBODY></TABLE>
hi experts,
Can someone help me to consolidate the data from (F1 - G9) to look like as (A1 - B5)?

Thanks in advance.

gigi

Try this...

Select the entire range F1:G9
Hit function key F5
Click the Special button
Select Blanks>OK
Right click>Delete>Shift Cells Up>OK

 

[p45cal]

If on any row in column F anf G, there is missing data against a name, or a missing name against data, wigi and Biff's solutions may result in misalignment of data.
You could simply sort the two columns.
If you wanted to retain the original order, before you sort, in cell H1 enter a 1, and in H2 enter a 2, then drag and fill down to create 1,2,3,4 etc, sort the three columns on F or G, then select only the top portion of the three columns with data in and sort on column H. This restores the original order. Then clear or delete the numbers in column H.

 

[gigiyi]

thanks all expert,

and p45cal help me out what i have concerned.

gigi