Hello, I wanted to know if we can find the average value of a row instead of a column for a select number of columns, and if yes, then how to do that. Here’s a brief example to make y’all understand what I mean:
Say I have a table of commodity prices (gold, silver, oil, etc) with maybe 10 columns, some containing names, dates, etc. And amongst those columns, say I have 4 similar columns which show the price of a commodity for 4 consecutive years. I want to find the average price of a commodity say Gold spread across the 4 years. Is it possible to find the average of the row containing Gold data only for those 4 specific columns?