ST Alpha - "is one of the columns not initially set to text or something?" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 152

In response to "I need remedial help in Excel for stacking columns (because it's so needlessly more complex than Google sheets)" by Max

is one of the columns not initially set to text or something?

Posted by JaxSean (aka JaxSean) Oct 13 '21, 12:11

create a new column, make sure the column is set to text, copy & paste (as values) from A:A to new column?

Responses:

I think I also need to avoid copy/paste because each sheet is hundreds of rows of data which continue to be updated. - Max Oct 13, 12:16 3
- 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

Replies are disabled on threads older than 7 days.