Power query question - dates into columns

[Mendy32]

Hi,

I need help.!! how can I combine the names to one row but have all the dates in columns with the Level underneath the Dates...Can this be done power query?

I need to look like this for example

I.d	Name	DOB	RAE	SEX	ADMIT	3.9.2020	3.16.2020	3.25.2020	etc...
6858	Wonder Woman	9/15/2000	PINK	Male	2/16/2020	H0	H0	H0	H0
7848	Superman	8/31/1976	White	Male	6/4/2020	H0	H0	H0	H0

The list below is what I need combined...

I.d #	Name	DOB	RAE	SEX	ADMIT	Level	Dates
6858​	Wonder Woman	9/15/2000​	PINK	Male	2/16/2020​	H0	3.9.2020
6858​	Wonder Woman	9/15/2000​	PINK	Male	2/16/2020​	H0	3.16.2020
6858​	Wonder Woman	9/15/2000​	PINK	Male	2/16/2020​	H0	3.25.2020
6858​	Wonder Woman	9/15/2000​	PINK	Male	2/16/2020​	H0	4.1.2020
6858​	Wonder Woman	9/15/2000​	PINK	Male	2/16/2020​	H0	4.8.2020
6858​	Wonder Woman	9/15/2000​	PINK	Male	2/16/2020​	H0	4.15.2020
6858​	Wonder Woman	9/15/2000​	PINK	Male	2/16/2020​	H0	4.22.2020
6858​	Wonder Woman	9/15/2000​	PINK	Male	2/16/2020​	H0	4.29.2020
6858​	Wonder Woman	9/15/2000​	PINK	Male	2/16/2020​	H0	5.6.2020
6858​	Wonder Woman	9/15/2000​	PINK	Male	2/16/2020​	H0	5.20.2020
6858​	Wonder Woman	9/15/2000​	PINK	Male	2/16/2020​	H0	5.27.2020
6858​	Wonder Woman	9/15/2000​	PINK	Male	2/16/2020​	H0	6.3.2020
6858​	Wonder Woman	9/15/2000​	PINK	Male	2/16/2020​	H0	6.10.2020
6858​	Wonder Woman	9/15/2000​	PINK	Male	2/16/2020​	H0	6.17.2020
6858​	Wonder Woman	9/15/2000​	PINK	Male	2/16/2020​	H0	6.24.2020
6858​	Wonder Woman	9/15/2000​	PINK	Male	2/16/2020​	H0	7.1.2020
6858​	Wonder Woman	9/15/2000​	PINK	Male	2/16/2020​	H0	7.8.2020
6858​	Wonder Woman	9/15/2000​	PINK	Male	2/16/2020​	H0	5.13.2020
7848​	Superman	8/31/1976​	White	Male	3/6/2020​	H0	3.16.2020
7848​	Superman	8/31/1976​	White	Male	6/4/2020​	H0	6.10.2020
7848​	Superman	8/31/1976​	White	Male	6/4/2020​	H0	6.17.2020
7848​	Superman	8/31/1976​	White	Male	6/4/2020​	H0	6.24.2020
7848​	Superman	8/31/1976​	White	Male	6/4/2020​	H0	7.1.2020
7848​	Superman	8/31/1976​	White	Male	6/4/2020​	H0	7.8.2020
7848​	Superman	8/31/1976​	White	Male	6/4/2020​	H0	7.15.2020
7848​	Superman	8/31/1976​	White	Male	6/4/2020​	H0	7.22.2020
1587​	ROQUE	11/8/1993​	PINK	Female	2/25/2020​	H0	3.9.2020
6584​	BATMAN	3/20/1992​	ORANGE	Male	10/4/2019​	H0	5.20.2020
6584​	BATMAN	3/20/1992​	ORANGE	Male	10/4/2019​	H0	5.27.2020
6584​	BATMAN	3/20/1992​	ORANGE	Male	10/4/2019​	H0	6.3.2020
6584​	BATMAN	3/20/1992​	ORANGE	Male	10/4/2019​	H0	6.10.2020
6584​	BATMAN	3/20/1992​	ORANGE	Male	10/4/2019​	H0	6.17.2020
6584​	BATMAN	3/20/1992​	ORANGE	Male	10/4/2019​	H0	6.24.2020
6584​	BATMAN	3/20/1992​	ORANGE	Male	10/4/2019​	H0	7.1.2020
6584​	BATMAN	3/20/1992​	ORANGE	Male	10/4/2019​	H0	7.8.2020
6584​	BATMAN	3/20/1992​	ORANGE	Male	10/4/2019​	H0	7.15.2020
6584​	BATMAN	3/20/1992​	ORANGE	Male	10/4/2019​	H0	7.22.2020
6584​	BATMAN	3/20/1992​	ORANGE	Male	10/4/2019​	H0	5.13.2020
749​	Aquaman	8/14/1994​	Brown	Male	3/2/2020​	H0	3.9.2020
749​	Aquaman	8/14/1994​	Brown	Male	3/2/2020​	H0	3.16.2020
749​	Aquaman	8/14/1994​	Brown	Male	3/2/2020​	H0	3.25.2020
749​	Aquaman	8/14/1994​	Brown	Male	3/2/2020​	H0	4.1.2020
749​	Aquaman	8/14/1994​	Brown	Male	3/2/2020​	H0	4.8.2020
749​	Aquaman	8/14/1994​	Brown	Male	3/2/2020​	H0	4.15.2020
83870​	FLASH	6/24/1992​	Brown	Male	2/24/2020​	H0	3.9.2020
83870​	FLASH	6/24/1992​	Brown	Male	2/24/2020​	H0	3.16.2020
83870​	FLASH	6/24/1992​	Brown	Male	2/24/2020​	H0	7.8.2020
83870​	FLASH	6/24/1992​	Brown	Male	2/24/2020​	H0	7.15.2020
83870​	FLASH	6/24/1992​	Brown	Male	2/24/2020​	H0	7.22.2020
955882​	THOR	9/13/1985​	Brown	Male	6/17/2020​	H0	6.24.2020
787667​	IRONMAN	1/2/1972​	White	Male	10/31/2019​	H0	5.20.2020
787667​	IRONMAN	1/2/1972​	White	Male	10/31/2019​	H0	5.27.2020
787667​	IRONMAN	1/2/1972​	White	Male	10/31/2019​	H0	6.3.2020
787667​	IRONMAN	1/2/1972​	White	Male	10/31/2019​	H0	6.10.2020
787667​	IRONMAN	1/2/1972​	White	Male	10/31/2019​	H0	6.17.2020
787667​	IRONMAN	1/2/1972​	White	Male	10/31/2019​	H0	6.24.2020
787667​	IRONMAN	1/2/1972​	White	Male	10/31/2019​	H0	7.1.2020
787667​	IRONMAN	1/2/1972​	White	Male	10/31/2019​	H0	7.8.2020
787667​	IRONMAN	1/2/1972​	White	Male	10/31/2019​	H0	7.15.2020
787667​	IRONMAN	1/2/1972​	White	Male	10/31/2019​	H0	7.22.2020
787667​	IRONMAN	1/2/1972​	White	Male	10/31/2019​	H0	5.13.2020
5917854​	PRINCE	4/4/1988​	White	Male	4/19/2020​	H1	4.22.2020
57421​	MICKEY MOUSE	2/5/1970​	PINK	Female	9/10/2019​	H1	4.15.2020
57421​	MICKEY MOUSE	2/5/1970​	PINK	Female	9/10/2019​	H1	4.22.2020
57421​	MICKEY MOUSE	2/5/1970​	PINK	Female	9/10/2019​	H1	4.29.2020
57421​	MICKEY MOUSE	2/5/1970​	PINK	Female	9/10/2019​	H1	5.6.2020
57421​	MICKEY MOUSE	2/5/1970​	PINK	Female	9/10/2019​	H1	5.20.2020
57421​	MICKEY MOUSE	2/5/1970​	PINK	Female	9/10/2019​	H1	5.27.2020
57421​	MICKEY MOUSE	2/5/1970​	PINK	Female	9/10/2019​	H1	6.3.2020
57421​	MICKEY MOUSE	2/5/1970​	PINK	Female	9/10/2019​	H1	6.10.2020
57421​	MICKEY MOUSE	2/5/1970​	PINK	Female	9/10/2019​	H1	6.17.2020
57421​	MICKEY MOUSE	2/5/1970​	PINK	Female	9/10/2019​	H1	6.24.2020
57421​	MICKEY MOUSE	2/5/1970​	PINK	Female	9/10/2019​	H1	7.1.2020
57421​	MICKEY MOUSE	2/5/1970​	PINK	Female	9/10/2019​	H1	7.8.2020
57421​	MICKEY MOUSE	2/5/1970​	PINK	Female	9/10/2019​	H1	5.13.2020
5896907​	LASSO	7/9/1993​	ORANGE	Male	3/9/2020​	H0	3.16.2020
5896907​	LASSO	7/9/1993​	ORANGE	Male	3/9/2020​	H0	3.25.2020
5896907​	LASSO	7/9/1993​	ORANGE	Male	3/9/2020​	H0	4.1.2020
5896907​	LASSO	7/9/1993​	ORANGE	Male	3/9/2020​	H0	4.8.2020
5896907​	LASSO	7/9/1993​	ORANGE	Male	3/9/2020​	H0	4.15.2020
5896907​	LASSO	7/9/1993​	ORANGE	Male	3/9/2020​	H0	4.22.2020
5896907​	LASSO	7/9/1993​	ORANGE	Male	3/9/2020​	H0	4.29.2020
5896907​	LASSO	7/9/1993​	ORANGE	Male	3/9/2020​	H0	5.6.2020
5896907​	LASSO	7/9/1993​	ORANGE	Male	3/9/2020​	H0	5.20.2020
5896907​	LASSO	7/9/1993​	ORANGE	Male	3/9/2020​	H0	5.27.2020
5896907​	LASSO	7/9/1993​	ORANGE	Male	3/9/2020​	H0	6.3.2020
5896907​	LASSO	7/9/1993​	ORANGE	Male	3/9/2020​	H0	6.10.2020
5896907​	LASSO	7/9/1993​	ORANGE	Male	3/9/2020​	H0	6.17.2020
5896907​	LASSO	7/9/1993​	ORANGE	Male	3/9/2020​	H0	6.24.2020
5896907​	LASSO	7/9/1993​	ORANGE	Male	3/9/2020​	H0	7.1.2020
5896907​	LASSO	7/9/1993​	ORANGE	Male	3/9/2020​	H0	7.8.2020
5896907​	LASSO	7/9/1993​	ORANGE	Male	3/9/2020​	H0	7.15.2020
5896907​	LASSO	7/9/1993​	ORANGE	Male	3/9/2020​	H0	7.22.2020
5896907​	LASSO	7/9/1993​	ORANGE	Male	3/9/2020​	H0	5.13.2020
719​	CROWN	3/23/1993​	ORANGE	Male	7/17/2020​	H1	7.22.2020
5731998​	RED BOOTS	9/13/1994​	PINK	Male	8/30/2019​	H1	3.25.2020
5731998​	RED BOOTS	9/13/1994​	PINK	Male	8/30/2019​	H1	4.1.2020
5731998​	RED BOOTS	9/13/1994​	PINK	Male	8/30/2019​	H1	4.8.2020
5731998​	RED BOOTS	9/13/1994​	PINK	Male	8/30/2019​	H1	4.15.2020
5731998​	RED BOOTS	9/13/1994​	PINK	Male	8/30/2019​	H1	4.22.2020
5731998​	RED BOOTS	9/13/1994​	PINK	Male	8/30/2019​	H1	4.29.2020
5731998​	RED BOOTS	9/13/1994​	PINK	Male	8/30/2019​	H1	5.6.2020
5731998​	RED BOOTS	9/13/1994​	PINK	Male	8/30/2019​	H1	5.20.2020
5731998​	RED BOOTS	9/13/1994​	PINK	Male	8/30/2019​	H1	5.27.2020
5731998​	RED BOOTS	9/13/1994​	PINK	Male	8/30/2019​	H1	6.3.2020
5731998​	RED BOOTS	9/13/1994​	PINK	Male	8/30/2019​	H1	6.10.2020
5731998​	RED BOOTS	9/13/1994​	PINK	Male	8/30/2019​	H1	6.17.2020
5731998​	RED BOOTS	9/13/1994​	PINK	Male	8/30/2019​	H1	6.24.2020
5731998​	RED BOOTS	9/13/1994​	PINK	Male	8/30/2019​	H1	7.1.2020
5731998​	RED BOOTS	9/13/1994​	PINK	Male	8/30/2019​	H1	7.8.2020
5731998​	RED BOOTS	9/13/1994​	PINK	Male	8/30/2019​	H1	7.15.2020
5731998​	RED BOOTS	9/13/1994​	PINK	Male	8/30/2019​	H1	7.22.2020
5731998​	RED BOOTS	9/13/1994​	PINK	Male	8/30/2019​	H1	5.13.2020

 

[sandy666]

Yes for which one?

 

[Mendy32]

the last one post 29..

 

[sandy666]

here is a code

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Pivot = Table.Pivot(Source, List.Distinct(Source[Dates]), "Dates", "Level"),
    Type = Table.TransformColumnTypes(Pivot,{{"DOB", type date}, {"ADMIT", type date}})
in
    Type

also there is attached excel file

 

[Mendy32]

it worked..it worked...thank you THANK YOU!!!!

 

[sandy666]

You are very welcome, I am glad you are happy
Thanks for the feedback
and you know I like Like ?

 

[Mendy32]

Can you suggest a book or a website to learn M codes?

 

[Mendy32]

yes, i forget about the likes

 

[sandy666]

yes, i forget about the likes

this is not mandatory but nice to see if someone appreciate your work ?

• What is PowerQuery (Get&Transform)
• Getting started with PQ
• PowerQuery Help
• PowerQuery M reference (erratum required)

Books, hm
for total novice it could be: M is for (Data) Monkey
but there is much more books, advanced or not

 

[Mendy32]

Once again...Thank you so much. I will take your suggestions. Have a good night!

 

[sandy666]

Greetings, same to you