I have a google sheet with various rows of data, in one column (Column E), the values for each row follow the following pattern:
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