none
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.

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

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


    Thank you.

    -Dom


    http://powerpivotforum.com.au/viewtopic.php?f=5&t=666


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

Answers