SOLVED

Iron Contributor

# 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 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

6 Replies
best response confirmed by anupambit1797 (Iron Contributor)
Solution

# Re: Filter Issue

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.

# Re: Filter Issue

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``````

# Re: Filter Issue

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;

# Re: Filter Issue

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

# Re: Filter Issue

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

Br,

Anupam

# Re: Filter Issue

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
1 best response

Accepted Solutions
best response confirmed by anupambit1797 (Iron Contributor)
Solution

# Re: Filter Issue

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.