Pivot table. Select non-consecutive columns
Hi,I would like your help to solve an issue for me:
When I have a wide range of data (in columns, say from A to X) and I only need the values in columns A and X, how can I then avoid to include the whole range of data in the pivot table range? (As is: Range A:Z. Would like: A:A Z:Z).
Thanks in advance for your help.
Kind regards
Arne