How to Combine rows of web table by order (every 2 rows)

[IbisRipley]

Hello All,

I am using the following code in power BI to get a table of prior version values for a given list item.

let
    Source = Web.Page(Web.Contents("<site>/_layouts/15/versions.aspx?list=xxxx-61cc-405d-xx-c411eaa43b90&ID=17")),
    Data0 = Source{0}[Data],
    #"Changed Type" = Table.TransformColumnTypes(Data0,{{"No.", Int64.Type}, {"Modified", type any}, {"Modified By", type any}}),
    #"Removed Bottom Rows" = Table.RemoveLastN(#"Changed Type",1)
in
    #"Removed Bottom Rows"

However, The data on the page is split on to 2 lines/record.  I am having trouble deciding the logical list of steps to join them

together.  The table "removed Bottom Rows" looks like:

Each desired record has it's value ( metric number value) one row below and with the header "metric number value" in the row below.

I am trying to get to the set of steps to just get data as [no] , [modified], [modified by] , [value]

Also,  many can probably already tell that the data comes from Sharepoint versions.aspx page.  I am open to other ways, butI have another ticket regarding that question and since I am on prem Sharepoint and power BI server some options were off the table.

ThanksFor any help you can provide

[pallmall]

This may not sound very helpful, but did you try to add the table by examples in the connector? Maybe the logic you are looking for is already provided by the connector itself. I would have tried it myself, but I'm lacking a suitable example 🙂

[IbisRipley]

ANY advice is helpful, thanks. Appologies for the lack of example (I was not sure which direction to go.) As for this suggestion, I was unable to navigate to the fields to select. I have now managed to get a solution to work by addimg a conditional column and using "copy up".