Combine to get average

[stormania]

Dear Excell Masters

Kindly help in attach file, how to get average that combine actual sales old pack & new pack

Thank you

 

[AlanSidman]

Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Removed Columns" = Table.RemoveColumns(Source,{"AVERAGE"}),
    #"Filtered Rows" = Table.SelectRows(#"Removed Columns", each ([NEW CODE] <> null)),
    #"Removed Columns1" = Table.RemoveColumns(#"Filtered Rows",{"OLD CODE"}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Removed Columns1", {"NEW CODE", "MATERIAL"}, "Attribute", "Value"),
    #"Grouped Rows" = Table.Group(#"Unpivoted Other Columns", {"NEW CODE"}, {{"Average Sales", each List.Average([Value]), type number}})
in
    #"Grouped Rows"

 

[stormania]

sorry alansidman, i don't know your formula
Maybe any familiar formula because i am a newbie
Kindly help, how to get average from combine 2 source code ? thank you

 

[vletm]

stormania
Write to cell D7 =AVERAGE(E3:I3,E7:I7) and copy down.

 

[AlanSidman]

Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

- Follow this link to learn how to install Power Query in Excel 2010 / 2013.

- Follow this link for an introduction to Power Query functionality.

- Follow this link for a video which demonstrates how to use Power Query code provided.

 

[stormania]

stormania
Write to cell D7 =AVERAGE(E3:I3,E7:I7) and copy down.

Dear Vietm

I mean that how to get average value for new code (cell D7, D8, D9) that combine for sales dec, sales nov for old code combine to new code (yellow cell)
Kindly help. Thank you

 

[stormania]

Kindly help any one for my problem., that how to get data average combine for new code that combine with old code. Average formula is a normal just average cell, but how to combine for new code (yellow cell) with include old code..thank you

 

[AlanSidman]

crossposted: https://www.mrexcel.com/board/threads/combine-2-source-code-new-code-to-get-average-help.1192262/

Please read the following: https://www.excelguru.ca/content.php?184

 

[vletm]

stormania
You should reread Forum Rules:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

There are clear sentences about Cross-Posting.

What is missing from #4 reply?
You're copying & pasting same phrases without any new information?