reshape

  1. D

    reshape grid for sumif calculations in vba

    Hi all I have a report that comes to me in several 'grids' in a workbook, and in order to report on it properly I need to make a small reshape. https://imgur.com/OaX4kdh These grids appear in one worksheet but have varying row lengths all the way down (separated by one blank row). I need to...
  2. K

    Reshape- Range (NRx7C) into ("N/3"Rx "3x7"C)

    Good Morning all, I am new in the forum. I am struggling to reshape a range, what I have tried with formulas but without success. I need to convert a range of NRx7C ( N = number of rows , C = number of columns ) which is constant in columns but not in rows (see attacthment "Source"). At the end...
  3. L

    Rearranging data in form of Panel Data

    Hello guys, Is there any way to rearrange data in this way for the following: : BEFORE: /////////[Ticker A] [Ticker B] [Ticker C] 2010 ///// 0,3 ////// 0,6 /////// 0,9 2011 ///// 0,7 ////// 1,4 /////// 2,1 2012 ///// 1,3 ////// 2,6 /////// 3,9 : LATER : 2010 Ticker A 0,3 2011...
  4. J

    Single Column --> 2d Grid

    Since it seems to come up every now and then, here's a quick generic routine/idea for reshaping single columns of data: Option Explicit ' -------------------------------------------------------- ' DECLARE APIs ' -------------------------------------------------------- Private Declare Sub...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top