Hello,

I know this question has been posted, but I will ask again: Can I create a
Pivot Table from two separate data ranges, e.g., different months' data on
different sheets? The data are laid out identically, i.e., same column
headings, same number of columns. Just different rows/records.

I have already scoured the postings on this topic and have tried the
solutions offered, and (1) consolidation doesn't give me useful results, and
(2) creating a MS Query doesn't work because the two ranges in question are
not joined or linked by a common field, but are actually two sets of
identically-laid-out data.

Is there actually no way to select-to-combine two non-adjacent ranges/lists
in a workbook to combine into one Pivot Table?

Thanks in advance for any advice you can offer,

Steve