How to use excels new formulas to make an unpivot formula | LAMBDA

=LAMBDA(array,HSTACK(TEXTSPLIT(TEXTJOIN(".",1,DROP(TAKE(array,,1)&"-"&TAKE(array,1),1,1)),"-","."),TOCOL(DROP(array,1,1))))
These formulas are only available in some versions of excel: techcommunity....

[@psmail007]

Quite possibly the most amazing Excel related video I have ever seen.

[@chubbyatheart]

Extraordinary video. Thank you so much.

[@ggneb2126]

Wow, you are the genius!

[@ana-mariavladan4973]

Excellent. Thanks for sharing. ❤

[@hemantabcde]

Brilliantly explained

[@garylbrown4]

Excellent!!! Thank you!

[@Bharatmsharma]

Superb work.. saw these formula in bits and pieces but making it as lambda and function was awesome work. Subscribed

[@martintaylor9356]

That is awesome! Having a bit of trouble getting PowerQuery to work at moment - absolutely LOVE this as alternative

[@heishoi]

wow ! this is so amazing

[@chungkien97]

I tried to do it before but not success. Thank you for your great video!

[@abc123birdsandbees]

Love this.. thanks.

[@2Bakz]

Thankyou so much. Exactly what I was looking for.

[@enjoyoffice]

That's awesome!!!!

[@bamakaze]

Brilliant!

[@johansanjaya3891]

thanks, very helpful tutorial, but only work in office 365

[@spoulis19]

Truly awesome! Have you ever worked on how to do the same thing, but the columns with data are 2, not one?

[@krishnakishorepeddisetti4387]

Nice video

[@SivaSankar-zq9bo]

Thanks for the formula

New Sub

[@kevinsullivan77]

If I want Column B to be dates , how do I modify the lambda function so that when the table spills the dates are numeric & in date format ?

[@TopBam]

Great video! Do you know how to do the same thing with multiple row headers?

[@rodrigoazevedo6783]

Add the columuns you wants and concatenate it using "-". It will only work on the custmized formula she explains in the beggining. Or if you create a Lambda function with this new assumption, the ranges used in the unpivot formula must have same number of columns. Hope it helps.