Forum Discussion
Gopal_Gope
May 14, 2024Copper Contributor
Need formula for help Excel
Same data in different columns has to be come to one column against the cell Please find the example in attachment
peiyezhu
May 14, 2024Bronze Contributor
sql:
select f01,sum(f02),sum(f03),f04,f05 from sheet1 group by f01,f04,f05
select f01,sum(f02),sum(f03),f04,f05 from sheet1 group by f01,f04,f05