How to retrieve value from a single column into multiple columns

Hi Data_enthu ,

Do you want to count by CRS_SUBJ and CRS_NBR grouping?

Here's an example.

You can use group by feature in Power Query. Select the both columns and click "Group By...".

In addition to adding a column with a count, add a column that retains the original rows.

Expand it.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.