Multiple Columns Based on Single Condition

[Anonymous]

Trying to generate several columns based on a single criterion. I have 200+ SKUs to get through and wanted to know if there was a quick way to accomplish this.

SKU	Product	Color	Pack	Product Qty	Shield Qty	Mask Qty
WM5PKCH1	Aries	Charcoal	5	1	0	5
WM5PKGR1	Aries	Grey	5	1	0	5
YTWM5PKCH1	Aries Youth	Charcoal	5	1	0	5
CSMFFP01	Cleaning Kit	N/A	1	1	0	0
300-022-001	Flex	Black	1	1	1	0
300-022-001	Flex	Black	1	1	1	0
300-022-005	Flex	Black	5	5	5	0

E.g. The given is the SKU and I am trying to generate all of the other columns based on the SKU. Any help would be appreciated!

[Greg_Deckler]

@Anonymous Would need a "SKU translation guide". Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.