Forum Discussion

zau73's avatar
zau73
Copper Contributor
Jul 15, 2024

How to re arrange data in excel?

Hi, Currently i have my parameters all in the same column. But i need to arrange them in rows and column. For example: I want to have the Name and Count as column, that means i only want to 2 ...
Excel
Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Jul 15, 2024

    zau73 You can use WRAPROWS() function

     

    =DROP(WRAPROWS(A1:A14,3,0),,-1)

     

     

    If you want to clean Name: and Count: strings then use SUBSTITUTE() function.

     

    =SUBSTITUTE(DROP(WRAPROWS(A1:A14,3,0),,-1),{"Name: ","Count: "},"")

     

     

Harun24HR's avatar
Harun24HR
Bronze Contributor
Jul 15, 2024

zau73 You can use WRAPROWS() function

 

=DROP(WRAPROWS(A1:A14,3,0),,-1)

 

 

If you want to clean Name: and Count: strings then use SUBSTITUTE() function.

 

=SUBSTITUTE(DROP(WRAPROWS(A1:A14,3,0),,-1),{"Name: ","Count: "},"")

 

 

  • zau73's avatar
    zau73
    Copper Contributor
    Jul 16, 2024
    Thank you, it works!

Resources