Great video! Suggestions for future videos: 1) XLOOKUP workaround for LO Calc, 2) Format as Table workaround for LO Calc, 3) Power Query for LO Calc and 4) Compatability checker (with newer and older versions of Excel). Thanks!
I have a 440+ row ODS file. One column specifies which file name I want to cut the individual rows to (file-a, file-b, file-c, or file-d). I understand how to use cut. But, how do I select rows by file destination name? And, once cut, how do I quickly remove the now vacant rows left by the cut? Is it better just to delete the unwanted rows and save the remainder under a new file name? Is there a better way?
Thank u 🎉
Great video!
Suggestions for future videos: 1) XLOOKUP workaround for LO Calc, 2) Format as Table workaround for LO Calc, 3) Power Query for LO Calc and 4) Compatability checker (with newer and older versions of Excel).
Thanks!
I have a 440+ row ODS file. One column specifies which file name I want to cut the individual rows to (file-a, file-b, file-c, or file-d). I understand how to use cut. But, how do I select rows by file destination name? And, once cut, how do I quickly remove the now vacant rows left by the cut? Is it better just to delete the unwanted rows and save the remainder under a new file name? Is there a better way?