Transform specific numbers into rows

Hi MaximeG ,

In Power Query, go to New Source>Blank Query then in Advanced Editor paste my code over the default code. You can then follow the steps I took to complete this:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSkrNSc8szVXSUTIFYiOlWJ1opbSixLzkVCDXGIgNlWJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [country = _t, sample = _t, vaccinated = _t]),
    chgTypes = Table.TransformColumnTypes(Source,{{"country", type text}, {"sample", Int64.Type}, {"vaccinated", Int64.Type}}),
    addUnvaccinated = Table.AddColumn(chgTypes, "unvaccinated", each [sample] - [vaccinated]),
    unpivotOthCols = Table.UnpivotOtherColumns(addUnvaccinated, {"country", "sample"}, "Attribute", "Value"),
    addList = Table.AddColumn(unpivotOthCols, "list", each {1..[Value]}),
    expandList = Table.ExpandListColumn(addList, "list"),
    remOthCols = Table.SelectColumns(expandList,{"country", "Attribute"})
in
    remOthCols

SUMMARY:

1) Add column with number of unvaccinated.

2) Unpivot [vaccinated] and [unvaccinated] columns

3) Add column creating list between 1 and vax/unvax value.

4) Expand list to duplicate rows.

Pete