I will have excel sheet with minium 500 coulmns and 1000 rows say
For sample to explain my question I attach a demo excel
All my columns have headers
I am looking to find all 2 way multiplication and add them as columns to my excel sheet and return it as a new excel sheet say
The column names for the new 2 way column should be like the
header name of column you are multiply * the name of the other columsn
Now in sample file if i multiple column with name A with column with name B I get a new column with header A*B the header name should be inserted and
Below that all the elements of that A column multiplied with that of B should come
I am looking to form columns for all possible2 way multiplication for the excel I will give.
As you can see the demo file
Excel_to_explain.xlsx
Kind help please