Rolling slabs of concrete laying out for you. If you put it anywhere else, it will still work, but your going to have to jiggy with the math a bit to get it to start from the the first entry in the row ( or the specific Wherever you want). You can also force it to stop at number of your choice. Job doneįor 30 columns/cells change T to AD, for 200 cells, change T to GR, etc. Change only the row references to refer to your 100's if different rows you need to do this for. Entire job task done in a minute-5.Ĭolumn B. I'm only using 1 formula to make each column. I only use 1 formula for column B and no more than 1 or 2 for column A (there are 3-4+ methods, no need to duplicate yourself but choose any of them to construct A). Start with column B and everything else becomes a doddle.
Note: Change D1 to the max column in Sheet1. Note: My formula to count the number of columns per row is: Then, the trick is to change the formulas in Column B in Sheet2: On Sheet2 I added a formula to count the number of columns per row. I would suggest you try to implement this simple example first, and then move it to your actual spreadsheet.ĮDIT: Regarding your comment, we could do a trick to make it work for a variable number of columns.įirst, lets add some variability to the number of columns in Sheet1. 
Then, just drag the formulas ( not the values in A1, B1), until you have the expected result. Cell G1: The number of columns in the data on Sheet1. Now, below are the formulas (or values) you would need to put in Sheet2 to make it work: Note that the first two columns are necesary for the formulas to work. Then, I have another sheet which returns what you want ( Sheet2). I have one sheet with all the data, lets call it Sheet1. I did it with formulas and will try to show you how below. #Excel for mac copy horizontal and paste vertacially code#
It can be achieved either with VBA Code or with formulas.
0 kommentar(er)
