🆕 How to Use WRAPROWS & WRAPCOLS Function in Excel #shorts

Microsoft introduced some very useful new functions in Excel. You can use them to rearrange your data in a dynamic way.

With WRAPROWS you can take a row or column of values and make it into a table with rows and columns. You just need to tell it how many values you want in each row.

The WRAPCOLS function is a tool in Excel that lets you change the shape of a row or column of data. It lets you change a list of values into a table of values. It does this by putting some values in different columns.

Requires Microsoft 365. These functions will not be available in Excel 2021 and earlier versions.

🚩Let’s connect on social:

👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel

[randallgreen]

I've used spreadsheets since the days of the Osborne luggabl, CPM, and SuperCalc. I've learned more in the last month while binge watching your channel than I have in a very long time. Thanks for sharing.

[Quijanos]

I think the best time to use either of these functions would be if what you're looking at is a long string of data either from the left to the right or from top to bottom. In that case, then you probably want to assemble the data in such a way that these functions would be useful.

[misterwill]

Thank you. I’ve been wondering what those two functions meant. Your video cleared them up.

[sachinrv]

Thank God I recently shifted to Office 365. Super cool functions

[rakeshpathak]

Thank you, a lot of new learning from your videos, keep making new videos

[adelfarghaly]

I cant't find function WRAPROWS on my spread sheet

[newmandoss]

Is there any options for multiple rows to use wraprows

[AalimOnlineOfficial]

I have wrapped data like you mentioned after applying the formula. I want the data in a row (like transpose function).is it possible?

[willm]

Hey I have a question what if the wrap count changes is there a way to make it dynamic, for example a list that is supposed to have 4 categories, but has 3 or 4 at some intervals. Please help

[huwpickrell]

Excel must have about hack and tricks 😮

[Neptune]

Great Leila, but can we 'unwrap' if it hasn't been wrapped in the first place? By the way I'm wrapt with your vid.

[hemalshahorigamilove]

Is it similar to unpivot in power query?

[martinargimon]

pressing those keys it does not wrok. nothing comes on the screen. Shame

[Satyendra]

𝗣𝗹𝗲𝗮𝘀𝗲 𝘁𝗲𝗹𝗹 𝗺𝗲 👋𝗺𝗮𝗺 𝘄𝗶𝗰𝗵 𝘀𝗼𝗳𝘁𝘄𝗮𝗿𝗲 𝘃𝗶𝗱𝗲𝗼 𝗲𝗱𝗶𝘁𝗶𝗻𝗴??