Forum Discussion
getting an average with multiples selected in slicer
I got it to work, but i have no idae how.
the actual column it was displaying was a % so i wanted it to show the average of all the slices added not the Sum of them. I removed it and put it back in but as i have next to no idea what im doing it worked this time.
Hi
I’m looking to import multiple files form folder in excel. Over 50. Each file has 150 column headers and the column headers are inconsistent. Can I create a list of ALL the column headers in ALL the files ?
I’ve watched several tutorials and they all refers to header mapping tables which I understand however …
Every tutorial I watch already has a header mapping table already completed because I’m importing multiple excel files with multiple column headers and it would be too time consuming to go through each file to understand the difference in column headers and create my before list in mapping header table.
Is there anyway you can get a list of ALL the column headers in ALL the files first and these would then serve as your before column in your header making table ?
I got it to work, but i have no idae how.
the actual column it was displaying was a % so i wanted it to show the average of all the slices added not the Sum of them. I removed it and put it back in but as i have next to no idea what im doing it worked this time.