Not Monitored
Tag not monitored by Microsoft.
37,800 questions
Power Query is no longer supported here on Q&A. Please post your question over on https://aka.ms/PQCommunity instead.
How to make a combination of 2 sets of records from different Queries into 1 Query?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 64%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETN%3C/text%3E%3C/svg%3E)
Tej Narayan Shaw
1
Reputation point
Inputs: Query 1= Roll(1,2) and Query 2=Name(Bill, Mark)
Desired Output: Query 3= Name/Roll(1/Bill,1/Mark, 2/Bill, 2/Mark)
1 answer
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 31%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
Ehren (MSFT) 1,781 Reputation points Microsoft Employee2022-02-18T20:49:06.28+00:00