Excel Pivot in Tabular Form

Question

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

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

Answer 1

Excel 365 Pro Plus with Power Pivot and Power Query.

Append and transform four Tables.

As per Andreas Killer.

With fictitious data.

With PivotChart and Slicer.

https://www.mediafire.com/file_premium/qdb8cluaesoiaow/03_31_22.xlsx/file

https://www.mediafire.com/file_premium/fsogygk60o17o67/03_31_22.pdf/file

Answer 2

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.