List report section headers on each row RRS feed

  • Question

  • I have a fixed length text file that I want to transform using power query. Each section has the name of the group above it, then the column headers and then the detail data. How can I get the name of the group to show up as the first column of each record?

    I attached two images. One of the raw report and one of the desired table.

    report fixed header 1.PNG
    report fixed header 1.PNG (6.87 KiB) Not viewed yet

    report fixed header 2.PNG
    report fixed header 2.PNG (7.45 KiB) Not viewed yet

    Thank you.


    • Edited by domtrump Sunday, May 7, 2017 8:00 PM
    Sunday, May 7, 2017 7:59 PM