How to Return ALL values from Sheet1 column to Sheet2
Is there a formula to copy all values in Sheet1 column Task to Sheet 2 column Task2?
Sheet1 is populated via form, so rows are consistently added.
What I can't do:
1) Adding a Helper column with numbers 1,2,3,etc to Sheet1 is a no go. So I can't Vlookup from Sheet2.
2) Index(Distinct will only return unique values. I need ALL values from Sheet1 (many are duplicates).
Thanks for any help with this.
Help Article Resources
Check out the Formula Handbook template!