Copy/ Paste Cells With Multiple Lines Doesn't Work
I've been digging through community for resolution to this issue, but I'm coming up empty.
I need to be able to copy/ paste multiple rows of data that have "multi-row (alt+enter)" information from Excel (and Smartsheet). Currently, when I try to copy and paste these "multi-row" cells, they spill into separate cells instead of staying together. It DOES work if I do them one at a time, but I have hundreds of rows of data - it's not a feasible solution to do it one at a time.
Is there a trick to being able to copy multiple rows and not have all of the information spill onto another separate row instead of the same cell? I've been using VLOOKUPs between Smartsheets to perform this task, but it is pretty painful.
Anyone have any tips??