ST Alpha - "I think I also need to avoid copy/paste because each sheet is hundreds of rows of data which continue to be updated." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 152

In response to "is one of the columns not initially set to text or something?" by JaxSean

I think I also need to avoid copy/paste because each sheet is hundreds of rows of data which continue to be updated.

Posted by Max Oct 13 '21, 12:16

Unless copy/paste somehow works for Excel's Tables.

As a test I did format the data as tables, and was successfully able to formulate:
=Sheet1!A2:A5&Sheet2!A2:A5 which concatenates the values into the destination cell rather than stacking the values, so I don't see why I'd be running into an error other than I'm simply too dim to figure out the right syntax to stack.

Responses:

can you use sumif to compile the data? -- nm - amanda jeans Oct 13, 12:21 2
- I don't think so? I'm not looking to sum numbers, this is to combine a list of text data - Max Oct 13, 13:40 1
  - I have an idea that might work using OFFSET, maybe? -- (edited) - znufrii Oct 13, 14:05

Post a message top

I think I also need to avoid copy/paste because each sheet is hundreds of rows of data which continue to be updated.

Replies are disabled on threads older than 7 days.