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.
Quite possibly the most amazing Excel related video I have ever seen.
Extraordinary video. Thank you so much.
LEN of the cell after result has to be taken care.
Perfectly working fine. Thank you.
Superb work.. saw these formula in bits and pieces but making it as lambda and function was awesome work. Subscribed
Wow, you are the genius!
Brilliantly explained
Excellent. Thanks for sharing. ❤
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 ?
That is awesome! Having a bit of trouble getting PowerQuery to work at moment - absolutely LOVE this as alternative
Truly awesome! Have you ever worked on how to do the same thing, but the columns with data are 2, not one?
Great video! Do you know how to do the same thing with multiple row headers?
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.
I tried to do it before but not success. Thank you for your great video!
wow ! this is so amazing
Excellent!!! Thank you!
Thankyou so much. Exactly what I was looking for.
Love this.. thanks.
Thanks for the formula
That's awesome!!!!
Brilliant!
Nice video
thanks, very helpful tutorial, but only work in office 365
New Sub