Page 1 of 1
Split and Pivot
Posted: Mon Jul 15, 2024 3:05 pm
by 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
Re: Split and Pivot
Posted: Mon Jul 15, 2024 4:12 pm
by 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
Re: Split and Pivot
Posted: Mon Jul 15, 2024 6:51 pm
by puriwutpokin
F3=IFERROR(--INDEX(TEXTSPLIT($D3,";"),XMATCH(F$2,TEXTSPLIT($C3,";"))),"") Copy right and down
Re: Split and Pivot
Posted: Fri Jul 19, 2024 7:54 pm
by sna
@puriwutpokin
It works well
Re: Split and Pivot
Posted: Fri Jul 19, 2024 7:57 pm
by sna
How to make it spill range without dragging?
Re: Split and Pivot
Posted: Wed Jul 24, 2024 9:03 am
by sna
puriwutpokin wrote: Mon Jul 15, 2024 6:51 pm
F3=IFERROR(--INDEX(TEXTSPLIT($D3,";"),XMATCH(F$2,TEXTSPLIT($C3,";"))),"") Copy right and down
This work,any amendment to make spill range.thanks
Re: Split and Pivot
Posted: Wed Jul 24, 2024 1:37 pm
by puriwutpokin
F3=IFERROR(--INDEX(TEXTSPLIT($D3,";"),XMATCH(F$2:K$2,TEXTSPLIT($C3,";"))),"") Copy down
Re: Split and Pivot
Posted: Wed Jul 24, 2024 1:37 pm
by sna
thanks