ST Alpha - "I need remedial help in Excel for stacking columns (because it's so needlessly more complex than Google sheets)" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 152

I need remedial help in Excel for stacking columns (because it's so needlessly more complex than Google sheets)

Posted by Max Oct 13 '21, 12:06

and since I need this to work on Sharepoint, no named ranges or VBA.

I simply need to stack data in Sheet1 A:A and Sheet2 A:A and Sheet3 A:A into Sheet4 A:A (which is really just my cheater step toward using Sheet4 A:A as the source List for data validation elsewhere).

Every syntax I try to use gives me "A value used in the formula is of the wrong data type."

Responses:

found a workable solution, though I think it's stupidly wordy compared to Google Sheets - Max Oct 13, 14:16
is one of the columns not initially set to text or something? - JaxSean Oct 13, 12:11 4
- 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

I need remedial help in Excel for stacking columns (because it's so needlessly more complex than Google sheets)

Replies are disabled on threads older than 7 days.