Create table from list of items

[mike.magill]

I have a table with a list of items and an integer against each item. I want to create a separate table with multiple rows for each item according to the integer and each row numbered (i.e)

Initial table

item A, 3
item B, 4

New table

item A, 1
item A, 2
item A, 3
item B, 1
item B, 2
item B, 3
item B, 4

Can anyone help? I know I should you List.Generate but can't work out the syntax

 

[alansidman]

Here is the result using PQ

v	A	B
1	Column1	Custom
2	item A	1
3	item A	2
4	item A	3
5	item B	1
6	item B	2
7	item B	3
8	item B	4

Mcode

//Table7 change to your table name

let
    Source = Excel.CurrentWorkbook(){[Name="Table7"]}[Content],
    #"Added Custom" = Table.AddColumn(Source, "Custom", each {Number.From(1)..([Column2])}),
    #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Custom"),
    #"Removed Columns" = Table.RemoveColumns(#"Expanded Custom",{"Column2"})
in
    #"Removed Columns"

 

[mike.magill]

Perfect! And so much simpler than I had imagined. Thanks.