Create another table that only shows certain data from another table

[jon16t]

Hi all,

I'm trying to tell more stories from a set of data and create charts from it.

Below table is a mini version of my original sheet which contains about 200 rows of data and grows every day

New table will only show Location and Note if the Note contains "*repeat*"

My current problem is it will show the first one, but it will not skip to the next one after its already counted. Essentially I don't know how to not count the ones that already have been counted.

Book1
	A	B	C	D	E	F	G
3	Original Table				New Table should look like
4	Location	Note			Location	Note
5	London				London	Repeat
6	London	Repeat			Paris	Repeat
7	Paris				Paris	Repeat x2
8	Paris	Repeat			Amsterdam	Repeat
9	Paris	Repeat x2			Rome	Repeat x5
10	Amsterdam				Paris	Repeat x4
11	Amsterdam	Repeat
12	London
13	Rome	Repeat x5
14	Rome
15	Paris	Repeat x4
16	Amsterdam
Sheet1

 

[etaf]

try
=FILTER(A3:B14,LEFT(B3:B14,6)="repeat")

Book4
	A	B	C	D	E	F	G	H	I	J
1	Original Table				New Table should look like
2	Location	Note			Location	Note
3	London				London	Repeat			London	Repeat
4	London	Repeat			Paris	Repeat			Paris	Repeat
5	Paris				Paris	Repeat x2			Paris	Repeat x2
6	Paris	Repeat			Amsterdam	Repeat			Amsterdam	Repeat
7	Paris	Repeat x2			Rome	Repeat x5			Rome	Repeat x5
8	Amsterdam				Paris	Repeat x4			Paris	Repeat x4
9	Amsterdam	Repeat
10	London
11	Rome	Repeat x5
12	Rome
13	Paris	Repeat x4
14	Amsterdam
Sheet1

Cell Formulas
Range	Formula
I3:J8	I3	=FILTER(A3:B14,LEFT(B3:B14,6)="repeat")
Dynamic array formulas.