Gentle Excel 🔰 vertical and horizontal shots

← Easy Excel time saving technique (@ oharu _ work)

Thank you for watching 😊

🎙️ Sound Ali Recommended

After downloading data from the system,

Have you ever experienced despair while standing in a row for some reason? 😭

Like me, copy and paste three lines at a time... It's hard when there's a lot of data.

At such times, the "WRAPROWS function" is supernatural.

With the specified number of columns (3 columns this time), the vertical data is neatly folded and made into a table ✨

[How to use]

= WRAPROWS (data range, number of items)

⚠️ [Important]

One point to avoid errors If the number of source data is not exactly a multiple of 3, the last "NAn error message "/ A" is displayed.

To prevent this, add a comma to the end of the formula and specify a space "" OK!

👇

Copy and use it!

= WRAPROWS (A2: A100, 3, "")

Please change the range according to the data at hand

This time I introduced it with 3 items, but even if it is 5 items or 10 items, you can express it in an instant just by changing the numbers 💻

It is also recommended to incorporate the "TOCOL function" that automatically skips blanks inside. I'll put a formula with settings to erase the error display

👇

= WRAPROWS (TOCOL (range, 1), number of items, "")

So that you can look back at any time later, it is convenient to [Save] from the "ribbon mark" in the lower right 🔖

* It may not work depending on the version or specification

Next time, we will make your daily life easier.

i will deliver it, so please save it and look back

*********************************************

Make some free time /

Mac 17 years | Windows 3 years

We are sending the struggle story of Excel de beginner 🔰.

Please like and follow me if you like

▶️ _ work

Please feel free to DM and comment

********************************************* "

Excel Time Shortening Easy Excel Excel beginner # excel _ beginner