3/31/2024 0 Comments Excel split cells by newline![]() #"Unpivoted Only Selected Columns" = Table.Unpivot(#"Filtered Rows",, "Attribute", "Value") #"Filtered Rows" = Table.SelectRows(Source, each null and ""), ![]() Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("tZBBCsIwEEWvMmRdIRV14U4QsdBCsOCmdBGa0QZqIulU6G08iyczVaFgUepCCIQM75P5L8tYgkoXsoKUGoWGWMDStiY8wQR4OJ/5d7yPIeR8CcLZi1boYC1b0AaoRIj1AT3DX9y041ZFQ9jTG9sYJUlbU7M8yJhH+9MPbtfHJ5EhZ1VTdDyQhec2A/pTfIdn60ibIwh/y2p0UPgNff9hLPFT72eLsqKybxWJN1WLv6n6zcxYEV9753c=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta ) in type table ), I assume that I have to unpivot to get the groupings together, but could not seem to get the split column by delimeter option to reak that section up. ![]() An example end state would look like this: ![]() I am looking to both unpivot this data as well as break the text into its own row so that I can see which course alignts to which program. In the 200 Level - ILT column, I have data that contains multiple titles in one cell. I have a table that looks like this that I am importing into power bi : CM Program ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |