How to Return ALL values from Sheet1 column to Sheet2

BrianDN

HI,

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.

Find more posts tagged with

Accepted answers

All comments

Austin Smith

Can you post a screenshot to help give context?

Without more data, and ruling out VLOOKUP and INDEX, and having duplicated sets of data, I'd say no, there's not a way to grab only one column's data and transpose it.

Andrée Starå

Hi @BrianDN

I hope you're well and safe!

Premium app, DataMesh.

Is that an option?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

BrianDN

Hi Austin & Andree,

Thanks for getting back to me.

No, DataMesh is not available to me.

Frame:

Sheet1 Column Task (Fed by form so rows will update)

Needs to equal Sheet2 Column Task2

Distinct would return:

And the problem with a numbered helper column in Sheet1, is that when a new entry is submitted in the form, the new row added to the top of the sheet will NOT have an associated number in the Helper column. Notice that the new entry (Cherry) has a blank in the Helper column instead if the desired "1".

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.