Filter Issue

[anupambit1797]

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 each of them has a corresponding RSRP for each set( as shown as an example in Yellow, orange etc)

From this , need to create the Output, so that each Antenna Id 1/3/4/7 has their RSRP values in 4 different columns as shown below:-

Both Legacy(Excel formulae) and PQ solutions are welcome.

Thanks & Regards

Anupam

[#2 · Accepted solution]

@anupambit1797 

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.

[#3]

@anupambit1797 

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

[#4]

@anupambit1797 

SQL:

create temp table aa as
select row_number() over ( partition by f01) grp,* from basic_to_two_dim;
cli_create_two_dim~aa~f01~f02;
select * from aa_two_dim;

 

[#5]

Hi, I may need help on creating data and output sheet but let me figure it out first then will ask for help.

[#6]

Thanks @peiyezhu , honestly I am not aware of SQL and the traditional sw computer languages.

Br,

Anupam

[#7]

You are welcome.
Please refer below sample about sql which can generate column headers at once.

https://e.anyoupin.cn/EData/?s=basic_to_two_dim