Text to Excel using Power BI

Iron Contributor

Dear Experts,

                  I need to create a Report from the attached Excel in the following format.

Step_1: The raw file( txt) from which we need to prepare the report is "Tx_Power". There are total 4 channels "SRS", "PRACH", "PUSCH" and "PUCCH" and for each channel we have an entry like this:-

anupambit1797_0-1692911849861.png

 

Step-2: I want to create an Excel(Sample_Power) as attached with the headers as populated , and all entries should be populated for each channel in format like below :-

anupambit1797_1-1692911976253.png

 

Thanks in Advance,

Br,

Anupam

 

 

 

 

1 Reply
Dear Experts, any response?