Group meta data fields after their order in a file (useful if you have multiples in the same file)

Group duplicated meta data fields after their order in file

Basic

const pages = dv.pages('"10 Example Data/dailys"').where(p => p.bought).sort(p => p.file.name)

const groupedValues = [];
for (let page of pages) {
    const length = Array.isArray(page.bought) ? page.bought.length : 1;
    for (let i = 0; i < length; i++) {
        groupedValues.push([
            page.file.link,
            getValue(page, "bought", i), 
            getValue(page, "paid", i)
        ])
    }
}

dv.table(["Page", "Bought", "Paid"], groupedValues)

function getValue(page, key, i) {
    return page[key] && Array.isArray(page[key]) ? page[key][i] : page[key]; 
}