stack columns

Why doesn't the formula work in column B when I change the range from A2:A1012 to A2:A2100? Why doesn't the formula work in column B when I change the range from A2:A1012 to A2:A2100? My File Thank you very much

Hello, I'm trying to create a pivot table to show the values of different payroll codes by state. But the data that I have is in one row. I have a formula to split it into separate columns, but I can't get this into a pivot table without looking very ugly. I want it to say something similar to...

Hi masters, Can anyone help me with a formula for stacking multiple columns data into one column. wherein it copies per column not per row. sample here: I hope anyone has an idea using excel 2016 here..please help me

Hi I have a lot of columns, around 400 and I'm trying to stack this columns on top of each other, making single column. In this example I would like to stack columns 3,4,5, 6 into a single column..and columns 1 and 2 to be repeated as many times as needed. Is there any solution to do that...

New to VBA and trying to piece together a macro but the table part is causing me problems. I have multiple "3 or 4 column" tables on a worksheet. I want to move a cell value by Double Clicking the cell on one table, then click anywhere on another table to move that cell value to that table...

Dear forum, I'm looking for a clean and light way to transform the way my data is stated. I succeeded in writing a code to stack several columns on top of another, running from the first row downwards to the first blank cell and jumping to the next column. As is shown in the table below, the...

Hi Everyone, I would like to create a vba that helps 1) Create a master sheet 2) Loop through all worksheets starting with " Data" 3) Copy column DH onwards to last column and stack them in one column on Master sheet , pasting them as values 4) If master sheet exists, to just replace...

Hi, I have a sheet with "raw data" with many columns (74+) and i need to stack them into one specific column on another sheet. This specific column has data already in it and above it. Basically, I need to take specific columns and stack them into one column on another worksheet where there is...

I have a large dataset with product related data in different columns for each data. <tbody> Date Product A Product A Product B Product B Qty Value Qty Value 01-09-2017 50 1000 40 800 02-09-2017 60 1200 20 400 </tbody> I want to make it columner base dataset...

Does anyone know how to do a 3D bar chart that is both clustered and stacked like in this picture. http://www.nevron.com/gallery/FullGalleries/chart/bar/images/XYZ_Stack_Bars_Chart.png

<table><tbody><tr><td class="votecell"> </td> <td class="postcell"> I'm new to excel and VBA and I'm stuck at this problem. I have columns A through AKP (A:AKP) with data, and there is a varied number of rows for each column. If possible, I need a macro that will...

Hi All, I am not able to work on the Stack Column Chart in VBA. One main reason i understood from the debug was its not able to reference to particular chart when it becomes active. Help on this would be very much appreciated. And second aspect is if there is any workaround in working out...

Is it possible to show two stacked columns for each y axis? I have tried to use a secondary axis but this gives me an overlapping of the 2 columns, when i need the 2 stacked columns to be side by side. I am trying to show analysis of revenue and cost for two telephone numbers, side by side for...