Power BI for Business Users (Beginners Welcome)

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

Power BI merge cell of rows in to a single row in a single cell

  • 1.  Power BI merge cell of rows in to a single row in a single cell

    Posted 12 days ago
    Hello All,
    I have a source from pdf as below. Names/data splitted in two rows instead of in a cell( single row). The final output should be in a single row by merging first two rows as a single row ( null should go and data should add) and the third row should come as column ( with header as ' other staff' and under that ' Evan molly'. Thankful if any one could give step by step procedure of power query editor in power BI


    ------------------------------
    Rak J
    Coordinator
    ------------------------------