sethlim1995
New Member
- Joined
- Sep 27, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
In power query , you can merge two data source.
I have already done that but I want to retain just the duplicate ( side by side from merging two tables) values row of information.
Currently looks like this:. I need to just see:
E B C D E A B C D A
F G H J F. A F G H A
K L M N (blank) Q R S T Q
O P Q R (blank) Q V Z X Q
I have already done that but I want to retain just the duplicate ( side by side from merging two tables) values row of information.
Currently looks like this:. I need to just see:
E B C D E A B C D A
F G H J F. A F G H A
K L M N (blank) Q R S T Q
O P Q R (blank) Q V Z X Q