Remove Blanks from the sheet

[Ali Jaleel]

Hi every one. Basically I have an excel sheet by the name of Daily Morning Discussions (Rough). As you can see I have made a sheet named Summary at the end. Now when i select the cursor to Complete, it shall check the column J of the sheet named "Jobs Log Sheet" and shall write down the job description of column C in the sheet named "Jobs Log Sheet" against the corresponding values of column J and then write them down starting from Column B4 of sheet named "Summary". Now the most important thing is that I dont need any spaces in between but it should write doen continous values. I cant use the textjoin or filter formula since I have older version of excel. Please can somebody do this for me as I have tried this since morning but got no success. Thanks in advance

 

[Pecoflyer]

Hi and welcome
attached a Power Query solution (available as addin in XL2016)
Just add any data in your table and refresh the result table
(BTW "0" is text, oppose to 0 which is a number)

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Filtered Rows" = Table.SelectRows(Source, each ([Status] = "Completed")),
    #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"Equipment/Location", "Job Raised by", "Job Assigned to", "Expected Time to Complete", "Job Assigning Date", "Job Completion Date", "Status", "Remarks"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Job Description", "Jobs Completed"}})
in
    #"Renamed Columns"