Forum Discussion
Solved
Data Transformation pivot/unpivot?
Hi all, Below is a sample data in question I'm trying to move those Row in bold to the left hand side and repeat to match the rest of the rows I can manage the rest but really stuck at moving...
let Source = Table.FromRecords(Json.Document(Binary.Decompress(Binary.FromText("xdDLCoJAFAbgV5FZOzLHsdHcVbaRhC5uIlpYSQjTCDauondPicZLKm6i2Z3D98Oc//BAi5QDctHMCzCASZBebsxyc7kl4j3SYtwvd+ipKz81GabMqjwxqLJaU9qjJbSl1S2xetV/NdRtw1RGXPOSu8ySUy6TVGjrODvHQkbX2FV56E7TzRZTMqn1AoFfLAeKMZuBgXPZWElJW/69GGfuY5tBvZhVWCx7iwEgzQAxnOkHi5zzuiVfFqDH/vrk4ws=",BinaryEncoding.Base64),Compression.Deflate))), fx=(tbl)=> let sTbl = Table.RemoveLastN(tbl,2), p1 = sTbl[Col1]{0}, p2 = sTbl[Col2]{0}, toLists = List.Skip(Table.ToRows(sTbl)) in List.TransformMany(toLists,each {{p1,p2}},(x,y)=>y&List.RemoveLastN(x)), group = Table.Group(Source,"Col3",{"t",fx},0,(x,y)=>Byte.From(y="YES")), toTbl = #table(null,List.Combine(group[t])), chType = Table.TransformColumnTypes(toTbl,{{"Column4", Percentage.Type}}) in chTypeIf this works for you, please mark it as the solution.
