Combining 2 tables

[david gabra]

Hi Guys
I have absolutely no idea how to do this am hoping you can help me.
I will attach a sample file, with the two source tabs and output tab - the output tab is what I need you please to make work.

There is a connection between the group and user name (tab 2)
and in tab 1 between the transaction and group name.

I need to have a list that list the transaction for each user. - there can be a user in more that one group,

David.

 

[rahulshewale1]

hii @david gabra ,


See if Is ok ?

Power Query Solution.


Regard
Rahul shewale

 

[david gabra]

Amazing- I do not see how it was done. I would like to learn. -thanks

 

[rahulshewale1]

Dear @david gabra ,


if you are using excel 2010 or above version then you can install power Query add in from Offical Microsoft SIte

https://www.microsoft.com/en-in/download/details.aspx?id=39379


1) Convert sheet 1 Data into table ( Ctrl + T )
2) Clink anywhere in table Go to > Power Query Tab > From Table / Range > Close and load to > only connection only


3) Convert sheet 2 Data into table ( Ctrl + T )
4 )Clink anywhere in table Go to > Power Query Tab > From Table / Range > Close and load to > only connection only

5) Power Query Tab >> Combine Queries > Merge > Select Table 1 > Select Group Name > Select table 2 > Select Group Name > ok>

6 ) Click Table2 Expand Button > Ok > Select Group Name Column> Close & Load (1st option ) Left Side



Regard
Rahul shewale

 

[AlanSidman]

Click on the links below.

What is Power Query
Power Query-How to use Mcode

 

[david gabra]

thank you