Transpose Multiple values column with unique valued column with matched multiple values

Lists-Logic
,
1

Hello,

I am trying to transpose/ pivot the list with multiple values as shown below:
The source excel table looks like this:
image
And I would like to achieve the reversed list with unique Project list with assigned name list as shown below:
image
With Dynamo sandbox, I could get the sorted list, but not sure how I can create a list of matching names.
This is where I am:

image
image4090×1310 370 KB

Any guidance/ help would be much appreciated.
Testing1.xlsx (9.7 KB)

ExportMembers_v2.13.0.3_test.dyn (32.4 KB)

2

Hi @fracTAL_MR

Like this?

Image1
Image13668×638 181 KB

ExportMembers.dyn (33.9 KB)

2 Likes
3

trns_2022-01-11_08-23-57
trns_2022-01-11_08-23-572254×594 75.1 KB 

c = List.Flatten(List.AddItemToEnd(a<1>,b<1><2>),1);
d = List.GroupByKey(List.LastItem(c<1>),List.FirstItem(c<1>));
e = List.SortByKey(d["groups"],d["unique keys"]);

trns.dyn (16.1 KB)

3 Likes
4

@EdsonMatt , @Vikram_Subbaiah Thank you so much, guys.
They all work great! I really appreciate it. I marked @EdsonMatt 's as a solution as it came first-, however, I appreciate your alternative solution, @Vikram_Subbaiah. I really like the use of group and key. Thank you! :grinning:

2 Likes