Excel Pivot in Tabular Form

Anonymous
2024-01-31T13:04:59+00:00

Hello,

I have a Workbook with two sheets. Each Sheet has two tables. Each table has the same column's headers.

Column A in every table has different information, the other columns could have same information.

My questions are:

  1. Is it possible to have a Pivot Table in Tabular Form with the information from 4 tables ?

See Pic 3 vs Pic 4

  1. Can I sort the Tabular Form other than the 1st column ?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes
Answer accepted by question author
  1. Andreas Killer 144K Reputation points Volunteer Moderator
    2024-01-31T13:47:27+00:00

    Use Power Query to stack up the data.

    Append queries (Power Query)

    Load that into a data model and create a Pivot table from there.

    If you need further help I need to see your (sample) file.
    Why a sample file is important for troubleshooting. How to do it. - Microsoft Community

    Andreas.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful