Combine multiple rows of lists to single cell of one list

[rajulshah]

Hello everyone,

I want to combine the 3 lists below into one list - 

Can anyone please help?

Thanks in advance.

[AndrewPF]

There is a List.Combine function: 

List.Combine - PowerQuery M | Microsoft Learn

You may need to transpose / pivot your data first. 

[Ahmedx]

Is this what you are looking for?

Combine multiple rows.mp4

or

[rajulshah]

@Ahmedx 
No, there should be one list comprising of all the lists