Forum Discussion
Solved
Filter Issue
Dear Experts, Greetings! I have an issue where I need to prepare a set from input sheet to Output sheet, In the "Input" sheet we have New Antenna Id, which can be 1,3,4,7 and eac...
I have attached a formula solution. I had to convert the table on the second sheet to an ordinary range, and to convert the text values1, 3, 4 and 7 in A1:D1 to numbers.
PQ:
let
Source = Excel.CurrentWorkbook(){[Name = "Table1"]}[Content],
Grouped = Table.Group(Source, "New Antenna ID", {"RSRPs", each [#"RSRP (dBm)"]}),
Sorted = Table.Sort(Grouped, {{"New Antenna ID", Order.Ascending}}),
Combined = Table.FromColumns(Sorted[RSRPs], List.Transform(Sorted[New Antenna ID], each Number.ToText(_)))
in
Combined