This was exactly what I needed to do, and you explained it clearly and quickly! You are a great teacher! Thank you. Really top notch

@ExcelOffTheGrid

10 ай бұрын

Thank you, that’s very kind of you to say.

Thank you so much! I've been trying to find a video explaining this process; you are the only one who showed it straightforwardly.

@ExcelOffTheGrid

Жыл бұрын

Glad it helped! 😀

best videos ever!

@ExcelOffTheGrid

2 жыл бұрын

Thank you 😊

THANKS A LOT ! This is exactly what I needed for a report.

@ExcelOffTheGrid

2 жыл бұрын

You’re welcome :-)

so less likes.. while this what we had been strggling for.. thank you so much..subscribed

@ExcelOffTheGrid

2 жыл бұрын

Glad it helped!

Very comprehensive

@ExcelOffTheGrid

2 жыл бұрын

Thanks. Hopefully it solved your problem.

Thank you very much!

Thanks!

@ExcelOffTheGrid

8 ай бұрын

No problem!

Hi Mark, awesome video mate!. question: if you were to develop the same solution with VBA, how long would it have taken you? p.s. Power Query is the hero without a cape.

@ExcelOffTheGrid

2 жыл бұрын

It would have taken me maybe 30 minutes of work to get the same result with VBA. It should be simple, but I hate working with arrays in VBA, they just don’t make sense in my mind. It would require lots of looping and error checking. Thankfully, Power Query is just a few clicks. 😀

0:14 Explanation 2:10 Demiliter (rows) 2:50 Demiliter

ONE CELL INTO TWO ROWS ONLY... NOTHING FUCKING ELSE

Could You help me pls split this data in the table into separate rows to integrate data into Mathcad drive.google.com/drive/folders/1ZhWrBfeBBwhLqElPTnEGMfTe31tXe2wA?usp=sharing