The WRAPCOLS FUNCTION

[vc_row][vc_column][vc_column_text]

WRAPCOLS Function

Excel for Microsoft 365 Excel for Microsoft 365 Mac Excel for Web

Wraps the provided row or column of values by columns after a specified number of elements to form a new array.

Syntax

=WRAPCOLS(vector, wrap_count, [pad_with])

 

The arguments in the syntax of WRAPCOLS are:

  • vector
    The vector or reference to wrap
  • wrap_count
    The maximum number of values for each column.
  • pad_with
    The value with which to pad. The default is #N/A.

 

Remarks

The elements of the vector are placed into a 2-dimensional array by column. Each column has wrap_count elements. The column is padded with pad_with if there are insufficient elements to fill it. If wrap_count is greater or equal to the number of elements in vector, then the vector is simply returned as the result of the function.

 

Examples

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.

 

Example1

Data
A B C D E F G
Formulas

=WRAPCOLS(A2:F2,3)

 

Example2

Data
A B C D E F G
Formulas

=WRAPCOLS(A2:G2,3,”x”)

[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][mk_image src=”https://peakup.org/wp-content/uploads/2023/12/office_imza_son.gif” image_size=”full” link=”https://peakup.org/global/office-training/” target=”_blank”][/vc_column][/vc_row]

PEAKUP IS ONE OF THE BEST IT EMPLOYERS

Great Place To Work has determined the best employees of the IT sector, and in this list PEAKUP found its place with the importance the company gives to its employees.

Being in the IT sector requires making quick decisions, being flexible, learning fast, implementing what you know, and following the innovations in the world. And PEAKUP has a young team just like that. The company’s employees evaluated PEAKUP and with those results, PEAKUP has been awarded with the Great Place to Work Certificate for the third time, and is in the 3rd place of the Best Employers.

With all the Great Place to Work awards, PEAKUP has experienced the happiness of being one of the best Employers of the IT sector once again. PEAKUP’s CEO Ahmet Toprakçı said: “I would like to thank our amazing team that allows us to get these awards every year for believing in PEAKUP.”

 

WE ARE IN THE IT 500 LIST ONCE AGAIN!

The results of the “Top 500 IT Companies Survey”, the only comprehensive survey in the field of IT in Turkey, have been announced.

The results of “Turkey’s Top 500 IT Companies Research”, which is highly anticipated by the IT world and includes companies that develop the technologies of the sector and produce solutions, have been announced. Organized for the 23rd time this year with the “Our Motto is Sustainability!” motto , the IT 500 Survey has come to the forefront as the most effective marketplace for both entrepreneurs and investors.

As PEAKUP, we are once again pleased to be included in the IT 500 list, which lists Turkey’s most valuable brands in the field of IT, just like we are every year.

WE HAVE SET OUR LNCH 23 TARGETS

As PEAKUP, we  started the new year all ready and we determined our strategies and targets at the LNCH event we had in the Sapanca NG Hotel.

On the first day of LNCH 23′, we set our targets and evaluated the whole year. PEAKUP members relieved the tiredness of the day in the pool and enjoyed the Disco at the end of the night.

On the second day, Ali İhsan Varol was the guest of our contest and then we gave our prizes. With two full days of LNCH 23, everyone started the year all ready for what is about to come.

We are the best workplace in the category of Best Workplaces for Women!

Türkiye’nin kadınlar için en harika işyeri PEAKUP oldu!

Great Place to Work®, an expert in workplace culture and employee experience, announced the list of Best Workplaces for Women Turkey 2022. Using deep insights from the Trust Index© survey of more than 100 million employees from all over the world since 1992 to define what constitutes a “Great Workplace” experience, Great Place to Work® analyzed the evaluations made by one of its employees in 2022 to reveal the best workplaces for women in Turkey.

PEAKUP’s CEO Ahmet Toprakçı said: “We would love to thank our amazing team -that always makes us receive Great Place to Work awards every year- for letting us get an award in a much more important category (Best Workplaces for Women). We are very happy to be the best workplace for women and create an amazing office environment with all our employees. We will always continue to work to do better.”