I need help filtering this so that i end up with $106$ rows. I$\text{'}$m using Power Query.

After working through the Power Query $($PQ$)$ sample Exercises $1-$

$8$ in Excel, create a report that shows the bike products offered

for the AdventureWorks database $($file provided below$).$ Each

product can be shipped in one or more colors, as well as$,$

multiple sizes. The associated colors and sizes are represented

in a comma$-$separated column. You will need to split the bikes

table to create a lookup table that associates product numbers

with colors and sizes. Do not include price or cost in your final

report.

Create a lookup table with $6$ columns: $1)$ Parent Product

Category Name, $2)$ Product Category Name, $3)$ Name, $4)$ Color,

Size, $6)$ Product Number

Include appropriate header row with column names

Each product number$/$color$/$size option should be listed separately as

it's own row

Split & trim data appropriately

Revise the Product Number to include the Color & Size. $($Example:

MK$-$M$82-$Black$-38)$

Give your new worksheet an appropriate title. Example: BikeOptions

Sort data by Name, Color, & Size ASC