Forum Discussion

anupambit1797's avatar
anupambit1797
Steel Contributor
Mar 11, 2026
Solved

Data Formatting

Dear Experts,                     I have a Data like below :- Each row can have 1 or more RNTIs( seperated by ",") and their DCI( UL_01 or UL_00),  I want to put them in a format like in Col - I~P...
BI & Data Analysis
Charting
excel
Formulas and Functions
office 365
power bi
  • OliverScheurich's avatar
    OliverScheurich
    Mar 11, 2026

    An alternative could be Power Query which works in Excel versions starting from Excel 2010. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.

    Thanks a lot PeterBartholomew1​ for providing the sample data in an Excel file and for the 365 solution.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Mar 11, 2026

An alternative could be Power Query which works in Excel versions starting from Excel 2010. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.

Thanks a lot PeterBartholomew1​ for providing the sample data in an Excel file and for the 365 solution.