Google spreadsheet, append the first columns of all sheets into one new column

Question

I have a google spreadsheet with multiple tabs. I would like to append all the element of the first columns of all tabs into one new column. How can I do this with a formula such that I can add or remove data from first columns, and also, add tabs without ever having to touch my new column?

Sheet 1 Column A    Sheet 2 Column A    New Column
Bob                 Mary                Bob
Joe                 Melissa             Joe
Jim                 Jackie              Jim
                                        Mary
                                        Melissa
                                        Jackie

I can't imagine any reasonable way to do this without scripting. — JNevill, Feb 13 '18 at 19:17
[More info here](https://developers.google.com/apps-script/guides/sheets) — JNevill, Feb 13 '18 at 19:20
This answer might help you https://stackoverflow.com/questions/9442099/stacking-multiple-columns-on-to-one . Long story short =filter(unique({Sheet1!A:A ; Sheet2!A:A}),NOT(ISBLANK(unique({Sheet1!A:A; Sheet2!A:A})))) — Anton Dementiev, Feb 13 '18 at 23:24

score 0 · Answer 1 · answered Feb 14 '18 at 12:46

0

google-spreadsheet

=query({'Sheet1'!A:A;'Sheet2'!A:A}, "select * where Col1 <> ''")

Please see more info on arrays {} here, and about query funcrion here.

excel

You'll probably need to use some VBA code for this.

answered Feb 14 '18 at 12:46

Max Makhrov

17,309
5
55
81

Google spreadsheet, append the first columns of all sheets into one new column

1 Answers1