paste transpose football matches into rows

[aaaaa34]

Hello friends,
I hope you're all doing well.
Honestly while cryptos failing like this, it's not easy to be well for me.

Well, I'd like to ask you a solution for my excel issue.
I have lots of football matches along A column with betting odds and infos regarding that match
Some odds for some matches are missing.
I want to move them into rows between columns B-J , it's kind of paste special (transpose)
Each new row needs to start with "Football" word.

Please have a look into attached file and you'll realize the thing to be done.

Thank you so much for visiting thread.
Nice evening & weekend.
Love you all.

[wk9128]

worksheet name : solved
Cell B2 Array formula , Drag down and across

[aaaaa34]

@wk9128 thanks for ur response
I applied the formula but it couldn't be possible to drag down as you see in the file below

[wk9128]

Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

[aaaaa34]

@wk9128
Ah now I got array formula, sorry for that
now I applied it properly but it didn't leave cells blank whicih doesn't have regarding data.
Please check the below.

[wk9128]

Pls ref (blue color area) Formula and The file has been updated, please download again P/S The animation files is the macro VBA code, and the attachment file is the formula

[aaaaa34]

I am not interested in what appears on column M and more right after that.
Cells in D:L region, I3:L3 and L5 should stay empty.

[aaaaa34]

That's it!!!
It worked great.
Thanks a lot pal @wk9128 , thanks for your time.

And thanks everyone for interested in this thread.
Love you excelforum.com

[wk9128]

You're Welcome. Thank You for the feedback

[cimbooom]

Tam aradığım dizi formülü, muhteşem yararlı olacak.