Hi,
i have a data contain 25 column. when i run a pivot table i need all these columns in rows tab (in pivot table)
is this possible to select all items from pivot fields list in a time. (just like select all)
screenshot is attached where i have select 4 headers....Data1...Data2...Data3....Data4... but my need is to select all items from choose field to Rows in a time.
i have a data contain 25 column. when i run a pivot table i need all these columns in rows tab (in pivot table)
is this possible to select all items from pivot fields list in a time. (just like select all)
screenshot is attached where i have select 4 headers....Data1...Data2...Data3....Data4... but my need is to select all items from choose field to Rows in a time.