Getting List.Count for each column Power Query

[ACraig08]

Hello,

I have a table like this:

I have been trying to find a way to convert each column so that they are a count of the number of items in each list for each row. One company used to have multiple rows and I used the Group By function first, then Aggregated Rows using List.Distinct so it have me a the result above. The end goal is the count within each list. I have been having the hardest time and am hoping I can avoid having to manually make a custom column for each one since I have like 30 columns. Any help is greatly appriciated.

[Ahmedx · Accepted solution]

to know how to do this watch my video

https://1drv.ms/v/s!AiUZ0Ws7G26RjFLL9CsEaSzn-65a?e=ENQDED

 = List.Skip( Table.ColumnNames( from),1)
 = Table.ReplaceValue( from, (x)=> x,(x)=>x, (x,y,z)=> List.Count(x), listmy)

[ACraig08]

OMG that was amazing! You also taught me how to had a function/step without having to chose one of the ones from the ribbion! I didn't know you could select the  symbol to insert your own thing! Thank you!!