I want to move information from worksheet 1 to worksheet 2. on worksheet 2
information from worksheet 1 is listed in one row and many columns. on
worksheet 1 information is listed in rows 1-320 and columns A-G. column A and
G are lists of names and column F is a classification, columns B-E have
numerical values or are empty. to avoid running out of columns on worksheet
2, I only want to move information from worksheet 1 to worksheet 2 when there
are numerical values in columns B-F on worksheet 1. I'll give an example
below, but I don't know if the formatting will mess up the columns.

worksheet 1

A B C D E F
Name 1 44 40-48 9% Very Low WJIII
Name 2 88 80-96 25% Low OWLS

worksheet 2
A B C D E F G
H I
Name 1 44 40-48 9% Very Low WJIII Name 2 88 80-96

J K L
25% Low OWLS

thanks, Lee