Skip to main content
Web Applications

Return to Question

added 6 characters in body; edited tags; edited title
Source Link
user0
user0
  • 27.1k
  • 10
  • 53
  • 78

Copy the contents of a row to another sheet based on a specific value - google sheets

I have a googleGoogle sheet with various rows of data, in one column (Column E), the values for each row follow the following pattern:

A1
A2
B1
B2
C1
C2 etc

A1   
A2  
B1  
B2   
C1  
C2 
etc.

I want to copy the rows containing all "A" values to one sheet, "B" values to another sheet and "C" to another, and so on for all other values (leaving the original data in a 'master' sheet).

Is this possible in google sheetsGoogle Sheets? So far the closest I have is: =filter("Sheet1"!A:E,"Sheet1"!E1:E1000="A1")

=filter("Sheet1"!A:E,"Sheet1"!E1:E1000="A1")

but this doesn't work for me unfortunately

Copy the contents of a row to another sheet based on a specific value - google sheets

I have a google sheet with various rows of data, in one column (Column E), the values for each row follow the following pattern:

A1
A2
B1
B2
C1
C2 etc

I want to copy the rows containing all "A" values to one sheet, "B" values to another sheet and "C" to another, and so on for all other values (leaving the original data in a 'master' sheet).

Is this possible in google sheets? So far the closest I have is: =filter("Sheet1"!A:E,"Sheet1"!E1:E1000="A1") but this doesn't work for me unfortunately

Copy the contents of a row to another sheet based on a specific value

I have a Google sheet with various rows of data, in one column (Column E), the values for each row follow the following pattern:

A1   
A2  
B1  
B2   
C1  
C2 
etc.

I want to copy the rows containing all "A" values to one sheet, "B" values to another sheet and "C" to another, and so on for all other values (leaving the original data in a 'master' sheet).

Is this possible in Google Sheets? So far the closest I have is:

=filter("Sheet1"!A:E,"Sheet1"!E1:E1000="A1")

but this doesn't work for me unfortunately

Source Link
2xtimes
2xtimes
  • 23
  • 3

Copy the contents of a row to another sheet based on a specific value - google sheets

I have a google sheet with various rows of data, in one column (Column E), the values for each row follow the following pattern:

A1
A2
B1
B2
C1
C2 etc

I want to copy the rows containing all "A" values to one sheet, "B" values to another sheet and "C" to another, and so on for all other values (leaving the original data in a 'master' sheet).

Is this possible in google sheets? So far the closest I have is: =filter("Sheet1"!A:E,"Sheet1"!E1:E1000="A1") but this doesn't work for me unfortunately