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
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
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)
