October 16, 2020
I've been using Excel extensively for years. Unfortunately, I'm a newbie to pivot tables, just started using them a couple of days ago, so if my questions don't make sense I apologize in advance...
I've got a Pivot Table in Excel that's bringing in a fair amount of data (from another Excel tab with a LOT of columns). Each row contains a Loan Number and loan information. I'd like the Pivot Table to grab specific loans, based on what filters I've put into place (this part is already done).
Because there are so many columns of data, I'd like the data to be split into two rows instead of one, so all columns will fit on one page. So basically each Loan Number would have two rows, and most of the cells in the second row would have data, some would not depending on how it should be organized.
Is this possible?
I'm still trying to understand how Pivot Tables work, and have realized I have a LOT to learn.
Thanks to anyone who replies!
July 16, 2010
Welcome to our forum! It's great to hear you're giving PivotTables a go. I'm sure you'll find them super useful.
To answer your question, my first reaction is 'no, it's not possible'. However, it's difficult to say there isn't a workaround without seeing your data and what you're hoping to achieve.
Are you able to upload a sample Excel file containing an extract of your data (anonymised if necessary) that illustrates the problem, and an example of how you'd like it displayed? There may be a solution/workaround.