P45cal,thanks.
I did try copying my real data onto the existing table w/o any success.
Attached is a sample data (a strip down version). Sheet2 is the expected result.
Over the weekend, I watched few introductions to power query videos. But, I’ve yet to learn enough to apply it to what I’m trying to accomplish.
TIA
Regard,
|