How do you populate a google sheets excel column with cells from a column in another sheet in the same document

0 votes

In my Google Sheets document, sheets 1, 2, and 3 will all have columns x, y, and z in addition to the main sheet, which will include these columns. Sheets 1, 2, and 3 depict several individuals who are filling in the columns with data.

The main sheet's function is to display all the data that has been entered into the three other sheets' columns x, y, and zin so that it may be viewed all at once. Each person can track their own personal information on sheets 1, 2, and 3 without also viewing all the information from other people's sheets.

I want to be able to have sheets 1, 2, and 3 automatically pull new data and put it in the appropriate column on the main sheet in chronological sequence. I am aware that it is possible to make some cells show data from another sheet, but ideally, I would like the cells to automatically fill the next empty cell in the column they are in. On essence, the main sheet's columns and those in the other three sheets have the same names, and I want the main sheet's columns to fill up whenever new data is entered into the corresponding columns in sheets 1, 2, and 3. This should make sense,

For instance, if column x in sheet 2 was filled in with the name Jane Doe, the main sheet should automatically populate Jane Doe into the next available cell in column x. Then someone types in John Smith into column x on sheet 1 and it automatically populates the cell after Jane Doe with John Smith in the main sheet.

Here is a demo sheet with how I would like it to be, with the columns in the main sheet populated with the items in all the columns from sheets 1, 2, and 3: https://docs.google.com/spreadsheets/d/1y0dldFtq6NtLPjU21HVedtUzYKi-MjLTz62tupYbZGY/edit?usp=sharing

Is it possible to connect sheets within a document like this? Thank you so much in advance! :) Let me know if you need any more information.

Dec 19, 2022 in Others by Kithuzzz
• 28,700 points
109 views

1 answer to this question.

0 votes

You have two options on chronology:

sheet-by-sheet

=QUERY({Sheet1!X:Z; Sheet2!X:Z; Sheet3!X:Z}, 
 "where Col1 is not null 
     or Col2 is not null 
     or Col3 is not null", )

enter image description here

row-by-row

=QUERY(SORT({
 Sheet1!X:Z, ROW(Sheet1!X:Z); 
 Sheet2!X:Z, ROW(Sheet2!X:Z); 
 Sheet3!X:Z, ROW(Sheet3!X:Z)}, 4, 1), 
 "select Col1,Col2,Col3
  where Col1 is not null 
     or Col2 is not null 
     or Col3 is not null"; )
answered Dec 19, 2022 by narikkadan
• 53,160 points

Related Questions In Others

0 votes
1 answer

Excel - How can I get the average of cells where the value in one column is X and the value in another column is Y?

Use AVERAGEIFS ... =AVERAGEIFS(C2:C13,A2:A13,"Yellow Typ ...READ MORE

answered Nov 11, 2022 in Others by narikkadan
• 53,160 points
156 views
0 votes
1 answer

How to unmerge multiple cells and transpose each value into a new column in Pandas dataframe from excel file

Try this: df = pd.read_excel("Sample_File.xlsx", header=[0,1,2,3,4,5], index_col = ...READ MORE

answered Jan 8 in Others by narikkadan
• 53,160 points
108 views
0 votes
0 answers

How do I get text in a pivot table in excel or google sheets?

I have a list of data that ...READ MORE

19 hours ago in Others by Kithuzzz
• 28,700 points
10 views
0 votes
0 answers

MS Excel - SumProduct formula with Loop

1 I have 4 arrays of data where ...READ MORE

Feb 18, 2022 in Others by Edureka
• 13,630 points
105 views
0 votes
1 answer

Thousand and million formatting for negative numbers (excel/ googlesheets)

Its not possible. What you could do is ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 53,160 points
160 views
0 votes
1 answer

How to split text values by a delimiter?

The Split function is what you are looking for: =Split(A1, ...READ MORE

answered Oct 11, 2022 in Others by narikkadan
• 53,160 points
153 views
0 votes
1 answer

Currency conversion:number to words excel

Try looking for javascript solutions to use ...READ MORE

answered Oct 28, 2022 in Others by narikkadan
• 53,160 points
90 views
0 votes
1 answer

How do I combine the first character of a cell with another cell in Excel?

Try this: =CONCATENATE(LEFT(A1,1), B1) READ MORE

answered Nov 7, 2022 in Others by narikkadan
• 53,160 points
100 views
0 votes
1 answer

In excel how do I reference the current row but a specific column?

Put a $ symbol in front of ...READ MORE

answered Oct 15, 2022 in Others by narikkadan
• 53,160 points
213 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP