Hi,
In Power Query I have 6 columns:
In the column [Warehouse] I have 2 values: “Main DC” and “Second DC”.
In the column [ProductCode] I have 1 value: “IO1234”.
In the column [ProductDescription] I have 1 value: “Product A”.
In the column [Sales Quantity Jan] I have 2 values: “2” which represents the sales for January for “[Warehouse] “Main DC” and “1” which represents the sales for January for “[Warehouse] “Second DC”.
In the column [Sales Quantity Feb] I have 2 values: “2” which represents the sales for February for “[Warehouse] “Main DC” and “1” which represents the sales for January for “[Warehouse] “Second DC”.
In the column [Sales Quantity March] I have 2 values: “2” which represents the sales for March for “[Warehouse] “Main DC” and “1” which represents the sales for January for “[Warehouse] “Second DC”.
I don’t want to differentiate [Sales Quantity Jan], [Sales Quantity Feb] and [Sales Quantity March] per [Warehouse] so I only want one value for [Warehouse] that aggregates the data for the other columns.
The output should be the following columns and values:
In the column [Warehouse] 1 value: “Main DC”.
In the column [ProductCode] 2 values: “IO1234” and “IO1235”.
In the column [ProductDescription] 2 values: “Product A” and “Product B”.
In the column [Sales Quantity Jan] “3” (which represents the sales for January for “[Warehouse] “Main DC” and “1” which represents the sales for January for “[Warehouse] “Second DC”.)
In the column [Sales Quantity Feb] “3” (which represents the sales for February for “[Warehouse] “Main DC” and “1” which represents the sales for January for “[Warehouse] “Second DC”).
In the column [Sales Quantity March] “3” (which represents the sales for March for “[Warehouse] “Main DC” and “1” which represents the sales for January for “[Warehouse] “Second DC”).
How can I achieve this? I tried the Group By option without success.
