Forum Discussion
Is there a way to "copy" all information from a row to another sheet based on specific information?
I have one Master sheet and 6 bureau sheets. The Master sheet has 21 columns: Last name, first name, case#, SSN, Assigned Bureau, etc. The Assigned Bureau column has 6 different options (C100, E100,...
Hello SergeiBaklan,
I need this same thing, but as you say, the point is to apply correct layout, and I can't figure that out.
I want the layout your sample file has, where, for example, all the names are in column A, all their phone numbers are in column B, addresses in column C... etc.
But what I get is Name in A4, phone number in A5, Address in A6, next name in A7, phone number A8 etc.
What is the trick to copy the rows from the Master and have them stay in rows in the pivot tables? Thank you for your help
I need this same thing, but as you say, the point is to apply correct layout, and I can't figure that out.
I want the layout your sample file has, where, for example, all the names are in column A, all their phone numbers are in column B, addresses in column C... etc.
But what I get is Name in A4, phone number in A5, Address in A6, next name in A7, phone number A8 etc.
What is the trick to copy the rows from the Master and have them stay in rows in the pivot tables? Thank you for your help
Aha! I found it--Tabular Layout.