Log In
Register
Home
Active Member
May 27, 2020
Offline
Hello
I have a query with Id numbers and 2 columns with lists.
Example:
| Id | List A | List B |
| 39 | [List] | [List] |
| 40 | [List] | [List] |
The data behind look like this, List A and List B can also have empty entries.
| Id | List A | List B |
| 39 | a | 1734 |
| 39 | b | 647 |
| 39 | c | 1913 |
| 39 | 1527 | |
| 40 | a | 1370 |
| 40 | b | |
| 40 | c | 1741 |
| 40 | d | 1386 |
I want to merge both lists by positions, but without expanding them first, the desired result should be
| Id | List A | List B | result |
| 39 | [List] | [List] | [List] |
| 40 | [List] | [List] | [List] |
I have no idea how to do that.
Thanks for your ideas.
Joerg
July 16, 2010
Offline
Hi Joerg,
Welcome to our forum! Please provide a sample Excel file so we can help you further.
Mynda
November 8, 2013
Offline
Try adding a new column with the formula:
List.Zip({[ListA],[ListB]})
Those 2 lists must have the same number of elements.
Active Member
May 27, 2020
Offline
Hello Mynda and Catalin
Unfortunately I can't upload a file, since the source is a sharepoint which you can't access.
List.Zip comes with error, because both lists have different nos. of elements.
This did now what I expected:
Table.ToRows(Table.FromColumns({[ListA],[ListB]}))
Thanks for your help.
Joerg
1 Guest(s)
