Forum Discussion
Link Pivot Table Report column headings to Field labelling
I have a very large CSV dataset (1.5GB) I have had to import into Excel as a Pivot Table Report. In order to save on space, the data provider uses codes for field names e.g. 'HE Provider' column is l...
You may Power Query csv file and Excel with codes as connections only. Merge them in separate query to combine with code names. Load this query as PivotTable into the grid.