Pulling through entire row of data - Google Sheets

[JJParis]

I have a tracker for my banking, and would like to seperate out the data based on which site the cost was attributed to - in Sheets my excel forumula wont work

I would like this to be my master and then have 2 separate for property 111 and 222, pulling across the entire rows into another sheet to create a P/L.

I am not sure how to upload a workbook.

However I have screen shots of raw data and what I would like the outcome to be.

VLookups are my kryptonite please help

 

[RoryA]

A gentle reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Pulling through entire row of data [SOLVED]

I have a tracker for my banking, and would like to seperate out the data based on which site the cost was attributed to. I would like this to be my master and then have 2 separate for property 111 and 222, pulling across the entire rows into another sheet to create a P/L. I have attached a...

www.excelforum.com

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[RoryA]

If you're using Sheets, then use the FILTER function.

 

[JJParis]

I dont want a filter - I want to be able to pull through the data to spearate sheets

 

[RoryA]

That is exactly what filter will do (and yes you do since you want to filter each sheet to one location)...