Can't create Pivot table with "multicolun" range and non adjacent columns

[Ochimus]

Immediate apologies if this has been covered elsewhere, but can't find it if it has.

As shown on the attached, Database has Date Received (Col C), Sales person (Col N), Product (which can be in Cols AA, AB or AC) and Contract Value (Col AD).

Can't manage to create a Pivot Table from these. Tried combining the columns into one range, but received an error message.

Hopefully someone can explain how to do this, or suggest an alternative approach?

Once I have the Pivot Table I can add the Date Span and Slicers allowing the choice of Values, Products and Sales people, and show the result as a Pivot Graph.

All solutions, suggestions and pointers accepted gratefully

Ochimus

[sandy666]

on sheet2 choose fields for your pivot table
done with PowerQuery (which is required)
or
use Alt, D, P to consolidate ranges to single PivotTable

[Ochimus]

Sandy,

Many thanks for the prompt response. Managed to cobble things together drawing on your revised attachment, but clearly need to explore advanced Pivot features, having used only a more straightforward data structure up to now.

Will mark this as solved.

Ochimus

[sandy666]

You are welcome

If that takes care of your original question, & to say Thanks and for better Motivation, please

1. click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)

If you did it already - ignore it.
Thank you.