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
The list below is what I need combined...
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 |