Merge rows based on the other column but do not combine rows that have different values in other col

[kaye_812]

I may have worded my problem really bad but it's really hard to explain. This representation might help. The table below is what I want it to look like. Thank you!

[AlexisOlson]

Try the solution here:
https://community.fabric.microsoft.com/t5/Desktop/TRICKY-Move-cell-up-in-certain-columns/m-p/2158720

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUXJKTAeSIBSrAxEJSM1LzsyBCIaU5iblpBbB5UBCiQWpyMqRhWIB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Number = _t, #"Content 1" = _t, #"Content 2" = _t, #"Content 3" = _t]),
    #"Replaced Value" = Table.ReplaceValue(Source,"",null,Replacer.ReplaceValue,{"Content 1", "Content 2", "Content 3"}),
    Custom1 = Table.FromColumns(List.Transform(Table.ToColumns(#"Replaced Value"), List.RemoveNulls), Table.ColumnNames(#"Replaced Value")),
    #"Filtered Rows" = Table.SelectRows(Custom1, each List.NonNullCount(Record.ToList(_)) > 1)
in
    #"Filtered Rows"

[rubayatyasmin]

Hi, @kaye_812 

For Content 1 column: Remove the null values. (by simply opening the table in power query and filter out the nulls)

For content 2 column: Replace null with Tape

 For content 3 column: Replace null with Tumbler

hope this helps. 

If my assistance helps you in any way, hit 👍 and accept the answer as a solution. 

Thanks

[kaye_812]

Hi, there are other values in Number Column which may also have other values for the conten1, 2, and 3 columns. I can't just simply change null values. Please see attached photo

 

[rubayatyasmin]

May I know if content 2 and 3 column value is coming from another table or not? As you mentioned something about the merge. 

[kaye_812]

No, they're not. This is the only table I have. 

[kaye_812]

What I want to happen, basically, is to merge rows but on the other hand, keep rows with the same Number column value separate if they completely have unique values from columns Content 1, Content 2, Content 3. The null values must also be populated if there exists a value in a column corresponding to the Number

[rubayatyasmin]

Can you try group by on Number and then Fill function? See if that works. 

If my assistance helped you in any way, appreciate the kudos. 

[kaye_812]

It doesn't work 😞 

[kaye_812]

Here's updated table to illustrate more my case 

 

[rubayatyasmin]

Sorry, I tried some possible solutions but couldn't achieve output like yours. 

[kaye_812]

Would you know any way to go about this?