stack data

Hello I have the follow VBA code which stacks all of column A on top of column B and so on. What I need it to do now is stack all of row 1 on top of row 2 etc. So rather than having: A1 A2 A3 B1 B2 B3... etc. It would instead be: A1 B1 A2 B2 A3 B3... etc. Any help would be appreciated, thank...

Hello, Any help with the following would be much appreciated! I currently have a table with which I would like to crate a stacked area chart (see reference image). I would like the y-axis to be the raw data (values between 0-1 you see below), and I would like the x=axis to be the years you...

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...

Hi All, I've the below code which does the trick but I get a runtime error 91 on the last line starting with "tbl" . I've used on error resume and it will happily work, but this is ofcourse not the answer. I believe the error lies in the fact that the data body range will be empty following the...

I have data that has been stacked prior to my receiving it. There are multiple rows of values for a single unifying ID. I'd like to convert those multiple rows into a single row by adding columns and pulling in a specified range of data. So my initial data looks like: <tbody> ID Name Subject...

Hi, I'm working on a data sheet/equipment list system for my business and need VBA code to minimize the filesize. For now i have two separate things i need help with: 1. I use a Table with 38 Columns to input my data. I want to have a button that adds a row to the bottom of the column with the...