Hello
I have two lists and I want to put each next to the other so that the values from one list that do not appear in the second list, have a blank value in the second list and vice versa.
E.g.
List1
1
2
3
List2
1
4
3
Result:
1, 1
2, NULL
NULL, 4
3, 3
I can do that with PowerBI by building a data model and putting the two lists one next to the other.
Is it possible to do that with Excel?
Thanks
I have two lists and I want to put each next to the other so that the values from one list that do not appear in the second list, have a blank value in the second list and vice versa.
E.g.
List1
1
2
3
List2
1
4
3
Result:
1, 1
2, NULL
NULL, 4
3, 3
I can do that with PowerBI by building a data model and putting the two lists one next to the other.
Is it possible to do that with Excel?
Thanks