0
I have the following table in Excel 2016:
ID Type1 Type2 Type3
1 01.03.2018 null 01.02.2019
2 01.04.2018 01.05.2018 null
3 null 01.03.2018 01.05.2018
Now I am trying to index those values into a new table which should look like the following:
ID 01.02.2018 01.03.2018 01.04.2018 01.05.2018
1 Type3 Type1 null null
2 null null Type1 Type2
3 null Type2 null Type3
What is the best way to achieve that? Using Power Query or with Excel functions? And how can I achieve that transformation?
What does you want to obtain when 2 different
TypeN
have the same date for differentID
? – Akina – 2019-09-18T13:15:25.087@Akina Duplication is possible. I just want to change the view, group the types by the dates by transforming the date to columns. – Mango D – 2019-09-18T13:18:09.210
Duplication is possible. And? does you want to obtain something like
Type5,Type8
in a cell with according row (ID value) and column (date value)? – Akina – 2019-09-18T13:22:14.560I want to achieve exactly what you see in table 2. For each ID there should be visible which types are occuring in which date. I want to transform table 1 to table 2. – Mango D – 2019-09-18T13:31:30.357