Split and Pivot

[sna]

Hi there!
I need to split and pivot the order table.
for example Fred has only 2 orders on 14th and 15th
required excel formula to solve this

Note: excel 365

[norkaz]

...

Hi

Could you please provide a few sample answers to the fields you’d like to solve in the Excel file? That way, I can assist you more effectively.

Bigcat9
Bangkok Thailand

[puriwutpokin]

F3=IFERROR(--INDEX(TEXTSPLIT($D3,";"),XMATCH(F$2,TEXTSPLIT($C3,";"))),"") Copy right and down

[sna]

@puriwutpokin
It works well

[sna]

How to make it spill range without dragging?

[sna]

F3=IFERROR(--INDEX(TEXTSPLIT($D3,";"),XMATCH(F$2,TEXTSPLIT($C3,";"))),"") Copy right and down

This work,any amendment to make spill range.thanks

[puriwutpokin]

F3=IFERROR(--INDEX(TEXTSPLIT($D3,";"),XMATCH(F$2:K$2,TEXTSPLIT($C3,";"))),"") Copy down

[sna]

thanks