Hi. Do you have the possibility to create a column C? In the new column C you could use the “&“ function and combine data. Here’s an explainer video ( link below ) <div style="display: block;" class="">Libre office how to combine data in two cells duckduckgo.com </a> Best RegardsHastham <br> On 2 Dec 2022, at 5:06 PM, . <SE@shch262.com> wrote: I want to be able to combine the contents of, say, column A into column B without losing data in any of the rows.Each column have blanks in certain rows so the data wont be overwritten.Example; A1 has data but B1 doesn'tA2 has no data but B2 doesCan this be done?Thanks,Peter--To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.orgProblems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/Posting guidelines + more: https://wiki.documentfoundation.org/NetiquetteList archive: https://listarchives.libreoffice.org/global/users/Privacy Policy: https://www.documentfoundation.org/privacy -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy