Home

Separate lines on Sheets depending on condition

%3CLINGO-SUB%20id%3D%22lingo-sub-876829%22%20slang%3D%22en-US%22%3ESeparate%20lines%20on%20Sheets%20depending%20on%20condition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-876829%22%20slang%3D%22en-US%22%3E%3CP%3Egreetings%20everyone%26nbsp%3B%3C%2FP%3E%3CP%3Ei'm%20newbie%20here%3C%2FP%3E%3CP%3Ei%20need%20to%20separate%20rows%20on%20Sheets%20depending%20on%20condition%20let%20me%20explain%3C%2FP%3E%3CP%3Ei%20have%203%20columns%26nbsp%3B%3C%2FP%3E%3CP%3E1-UserName%3C%2FP%3E%3CP%3E2-%20CustomerName%26nbsp%3B%3C%2FP%3E%3CP%3E3-Cost%3C%2FP%3E%3CP%3Ei%20need%20to%26nbsp%3Bseparate%20rows%20on%20Sheets%20depending%20on%20column%20User%20name%3CBR%20%2F%3ESo%20that%20each%20user%20on%20a%20separate%20page%20fetch%20their%20customer%20data%20on%20his%20pages%20and%20page%20name%20will%20be%20UserName%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-876829%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eorganize%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESheets%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-883381%22%20slang%3D%22en-US%22%3ERe%3A%20Separate%20lines%20on%20Sheets%20depending%20on%20condition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-883381%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F137290%22%20target%3D%22_blank%22%3E%40Mohammed%20Almaghi%3C%2FA%3E%26nbsp%3BIf%20you%20create%20a%20PivotTable%20with%20UserName%20in%20the%20Filter%20field%2C%20you%20can%20use%20the%20%3CA%20href%3D%22https%3A%2F%2Fwww.excelcampus.com%2Fpivot-tables%2Fshow-report-filter-pages%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EShow%20Report%20Filter%20Pages%20method%3C%2FA%3E%2C%20which%20will%20create%20a%20new%20PivotTable%20worksheet%20for%20each%20name%20in%20the%20list.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHTH%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Visitor

greetings everyone 

i'm newbie here

i need to separate rows on Sheets depending on condition let me explain

i have 3 columns 

1-UserName

2- CustomerName 

3-Cost

i need to separate rows on Sheets depending on column User name
So that each user on a separate page fetch their customer data on his pages and page name will be UserName

1 Reply
Highlighted

@Mohammed Almaghi If you create a PivotTable with UserName in the Filter field, you can use the Show Report Filter Pages method, which will create a new PivotTable worksheet for each name in the list.

 

HTH,