I would like to delete all of the empty {0×0 double} cells in each row, then shift the cells that have values in them to the left.
Starting with:
{["laterite-00001"]} {[ 30552]} {[ 227634]} {[ 123220]} {["laterite-00002"]} {0×0 double} {0×0 double} {[1345]} {["laterite-00003"]} {0×0 double} {0×0 double} {[443266]} {["laterite-00004"]} {0×0 double} {0×0 double} {[87887]} {["laterite-00005"]} {[1323]} {[87455]} {[23345]} {["laterite-00006"]} {[43233]} {[454547]} {0×0 double}
I would like to end with this:
{["laterite-00001"]} {[30552]} {[227634]} {[123220]} {["laterite-00002"]} {[1345]} {["laterite-00003"]} {[443266]} {["laterite-00004"]} {[87887]} {["laterite-00005"]} {[1323]} {[87455]} {[23345]} {["laterite-00006"]} {[43233]} {[454547]}
Best Answer