Forum

Change Pivot Table ...
 
Notifications
Clear all

Change Pivot Table from one row to two rows per data piece?

2 Posts
2 Users
0 Reactions
200 Views
(@duffman56)
Posts: 1
New Member
Topic starter
 

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!

 
Posted : 16/10/2020 5:33 pm
(@mynda)
Posts: 4762
Member Admin
 

Hi Jordan,

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.

Mynda

 
Posted : 16/10/2020 6:52 pm
Share: