Expand and extract from List and Table at the same time

[Anonymous]

Hi, 

I was working with two columns with lists, one that contains dates and the other the Hours assigned by each day that I zipped in a single column to expand them at the same time.

Still, I needed to expand the one with dates in order to remove the weekend days and when re-grouping I got a Table, not a list, so the command List.Zip didn't work to unify them and later expand them at the same time.

     

I need, either be able to change the table for a list, where the Column "Between Dates" is extracted as a list or a way in which I can EXPAND and EXTRACT the info for the list and the table at the same time.

I've been trying with different alternatives around the below option, all unsuccessful. 

= Table.ExpandTableColumn(#"Added Custom", "BTWN_DATES", {"Resource Name", "Job #", "Task", "Between Dates", "Day Name"}, {"Resource Name.1", "Job #.1", "Task.1", "Between Dates.1", "Day Name"})  &  Table.ExpandListColumn(#"Added Custom ", "Hour Assign Day")

Also with multiple alternatives to merging or concatenating the list and the table, but all give me "error" instead of a list.

Any help????

[v-yalanwu-msft]

Hi, @Anonymous ;

If you want to change the table for a list, you could try Table.ToList.

https://www.youtube.com/watch?v=LbjhhJQ7bO0

or you could share a simple example similar your table. and share the result you what to output.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.