Forum Discussion

Excel's avatar
Excel
Iron Contributor
Nov 20, 2020

Two different pivot tables into one

Hello Everyone, I have a customer list for my business. This list includes A1: Name, B1: Address, C1:Phone Number etc... (This is first part of my table) Then the values start:  K1: Number of Unit...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 20, 2020

Excel 

You may Power Query your source data and return by it as many tables as needed. Plus PivotTable from data model if necessary, but I guess all tables could be generated by PQ only.

  • Excel's avatar
    Excel
    Iron Contributor
    Nov 20, 2020
    How can i do?
    Can please explain?? PLEASE
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 20, 2020

      Excel 

      Does you version of Excel supports Power Query and do you have at least some experience with it?

      • Excel's avatar
        Excel
        Iron Contributor
        Nov 20, 2020
        Yes, it support Power Query... I know only basic thing..

Resources