Muhamad1986
New Member
- Joined
- Dec 19, 2019
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
Hi guys
How do I merge similar lists with power query in excel?
Input
list1= {a, b, c, d}
list2= {a, d, e, f}
list3= {f}
list4= {e, g, h}
list5= {a, e}
list6= {n1, n2, n3, n4}
list7= {i, j, k}
list8= {k, l, m, n}
list9= {i, l, o, p}
list10= {i, j, m, q, r}
Output
List1= {a, b, c, d, e, f, g, h}
List2= {n1, n2, n3, n4}
List3= {i, j, k, l, m, n, o, p, q, r}
How do I merge similar lists with power query in excel?
Input
list1= {a, b, c, d}
list2= {a, d, e, f}
list3= {f}
list4= {e, g, h}
list5= {a, e}
list6= {n1, n2, n3, n4}
list7= {i, j, k}
list8= {k, l, m, n}
list9= {i, l, o, p}
list10= {i, j, m, q, r}
Output
List1= {a, b, c, d, e, f, g, h}
List2= {n1, n2, n3, n4}
List3= {i, j, k, l, m, n, o, p, q, r}