converting model data/table

[johan58]

hello,

i have data in table 1. it contains names that has 4 items, every items has its own due date.

how to convert from table 1 into table 2?
of course use excel function/feature, not manually copy paste.

please provide in excel 2013 version and 2016 above if possible

thanks before
Simulation 5.xlsx

simulation 5.PNG

[AliGW]

Are you still using Excel 2021?

[Czeslaw]

Power Query

l

Please Login or Register  to view this content.

[DJunqueira]

With Excel 365 formula

Please Login or Register  to view this content.

[Czeslaw]

Formulas
Name

Please Login or Register  to view this content.

Item Type

Please Login or Register  to view this content.

"")

Due date

Please Login or Register  to view this content.

[DJunqueira]

Excel 2021 solution.

Please Login or Register  to view this content.