Outputting contents of cells to seperate worksheet only if a cell is not blank

[Paul Naylor]

I want to output contents of a column( if not blank) along with 2 other columns to a separate worksheet , but want all the results to show under each other and not have blank lines on the separate worksheet. Using combination of IF & Vlookup to display , but can't see a way to remove blank lines from the separate worksheet. It just replicates the relevant lines of the data worksheet.

On sheet 1
If cells in column j not blank wanting to output the cell contents this cell to a cell in column B of a new worksheet(sheet 2) , along with the contents of same cells in column A to column A in new sheet and contents same cell column K to column C the new sheet 2.

On sheet 2 don't want blank lines just lines containing data.