Forum Discussion
Solved
Pasting same table down columns multiple times
Hi I'm not sure if this can be done on excel but here goes. I have created a table from power query which shows all the combinations of 3 lists. What i am now trying to do is Copy the same table d...
You may edit current one:
et Source = Table.NestedJoin(Table5, {"Temp"}, Table6, {"Temp"}, "Table6", JoinKind.FullOuter), #"Merged Queries" = Table.NestedJoin(Source, {"Temp"}, Table7, {"Temp"}, "Table7", JoinKind.FullOuter), #"Expanded Table6" = Table.ExpandTableColumn(#"Merged Queries", "Table6", {"LDP"}, {"LDP"}), #"Expanded Table7" = Table.ExpandTableColumn(#"Expanded Table6", "Table7", {"Banding"}, {"Banding"}), #"Removed Columns" = Table.RemoveColumns(#"Expanded Table7",{"Temp"}) /////////////////// // ADD HERE , RepeatAbove = Table.Repeat( #"Removed Columns", 53) in RepeatAbove // #"Removed Columns"
You may add one more step to the final query like
...
result = Table.Repeat( prevStep, 53)
in
result- Hi where do i write this query ?
You may edit current one:
et Source = Table.NestedJoin(Table5, {"Temp"}, Table6, {"Temp"}, "Table6", JoinKind.FullOuter), #"Merged Queries" = Table.NestedJoin(Source, {"Temp"}, Table7, {"Temp"}, "Table7", JoinKind.FullOuter), #"Expanded Table6" = Table.ExpandTableColumn(#"Merged Queries", "Table6", {"LDP"}, {"LDP"}), #"Expanded Table7" = Table.ExpandTableColumn(#"Expanded Table6", "Table7", {"Banding"}, {"Banding"}), #"Removed Columns" = Table.RemoveColumns(#"Expanded Table7",{"Temp"}) /////////////////// // ADD HERE , RepeatAbove = Table.Repeat( #"Removed Columns", 53) in RepeatAbove // #"Removed Columns"SergeiBaklan The Power Query on my comp is not showing this query you have kindly shown.
Do you know how i can view this please ?
I can just see this in power query
