data arrangement

Hello, I have 2 data tables that get updated and carried forward every month. I have another tab that essentially has each table stacked on top of each other 8 times, with formulas and links to the data tables. When I insert new rows to the data tables, I would like the rows automatically...

Hi, So I have data organised as: <tbody> 16.66666667 0 16.66666667 0 0 0 16.66666667 0 16.66666667 16.66666667 </tbody> And I want to transpose it in sets of 3, like: <tbody> 16.66666667 0 16.66666667 0 0 0 0 16.66666667 16.66666667 </tbody> Can anyone help me? I need to do this...

Hi All, I am working with Excel 2016 I have an issue with a data set that I receive regularly which now comes in a different format to what I have set up all my systems for so I am hoping to find a simple fill down formula that will translate it to what I am used to. Original Data set looked...

Hi, I have a problem that I can't wrap my head around: My data looks like this: print screen windows 7 What I want is to allocate the "year founded" to the corresponding "Buyer/investor". So for the values/strings in "year founded" I need to a) allocate each to the corresponding value in...

Hey everyone. I have the problem that the data I am plotting in Excel is arranged in the following way: Rowid Count Value 1 2 1 2 3 4 ..... Is there a way to get excel to understand the structure of this data? So that...