how to expand list into pattern in Excel? -


I have a list like this:

  1 2 3 4 5  

I am dragging those numbers into a second spreadsheet, using vlookup.

I want to create a new list or pattern, which looks like this:

  1 1 1 1 1 2 2 2 2 3 3 3 3 3 .. Etc.  

How can I easily (my first list has 300 items, so

After this plan:

Use the formulas:

  c2 -> = A2C3 - & Gt; = Index (A: A, round down (ROO (G1) / $ B $ 2) +2; 0) and 'AutoComplete D2 -> = IF (ROUND UP (RAW (G1) / ($ B $ 2 + $ B $ 4); 0)) - (ROUNDDOWN (RAW (G1) / ($ B $ 2 + $ B $ 4)) ($ B $ 4 ) / $ B $ 2 $ B $ 4/10; 0)) = 1; Index (A: ROUNDDOWN (RAW (G1) / ($ B $ 2 + $ B $ 4)) + 2; 0) Columns  D  is relevant to replicate without any spaces, columns are  D ; and "AutoComplete  

C This is relevant to replicate with spaces.
Keeps the number of duplication B2 in the cells and puts the empty cell B4 in the cell.
If you have more copies to use a column, the same code for each column ...
If you only need the values ​​in the copy of the end, and paste it with the value. . WARNING: The formula in column D is in use with the number of spaces and repeat ... finally you need the library again.


Comments

Popular posts from this blog

Member with no value in F# -

java - Joda Time Interval Not returning what I expect -

c# - Showing a SelectedItem's Property -