let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Grouped Rows" = Table.Group(Source, {"Name"}, {{"Group", each _, type table}}),
// Start creating a list of names to intersperse with the existing names
#"Removed Columns" = Table.RemoveColumns(#"Grouped Rows",{"Group"}),
// Add a column containing the original name with "_Blank" appended
#"Added Custom" = Table.AddColumn(#"Removed Columns", "Custom", each [Name] & "_Blank"),
// Remove the original Name column
#"Removed Columns1" = Table.RemoveColumns(#"Added Custom",{"Name"}),
// Rename the new column to match the original data
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns1",{{"Custom", "Name"}}),
/* Append the new names to the previous data
For this step I appended the "Renamed Columns" step to itself
then I edited the step in the formula bar to use the "Grouped Rows" step
*/
#"Appended Query" = Table.Combine({#"Grouped Rows", #"Renamed Columns"}),
// Sort the records to place each new name below its parent
#"Sorted Rows" = Table.Sort(#"Appended Query",{{"Name", Order.Ascending}}),
// Add an index to keep the grouped records in that order
#"Added Index" = Table.AddIndexColumn(#"Sorted Rows", "Index", 0, 1),
// Remove the original "Name" column (it will be replaced in the next step)
#"Removed Columns2" = Table.RemoveColumns(#"Added Index",{"Name"}),
// Expand the new column
#"Expanded Group" = Table.ExpandTableColumn(#"Removed Columns2", "Group", {"Name", "Amount"}, {"Group.Name", "Group.Amount"})
in
#"Expanded Group"