Postoji ali jedino u VBA (neka me neko ispravi...). Uglavnom, ako ispratis bilo koji tutorial kako da pokrenes VBA editor u Excelu (Alt + F11) npr
Customize Ribbon -> Add Developer Tab -> (pa na Developer Tab) otvoris Visual Basic
(https://www.excel-easy.com/vba/creat...l-basic-editor)
(https://www.excel-easy.com/vba/examp...-a-module.html)
i uneses ovih par linija koda i stisnes dugme "Play" - dobices bas ono sto ti treba, izbrisi samo prve dvije kolone, i to je to.
Gif kako radi... https://giphy.com/gifs/ggv24IaijQtgCuvzAlCode:Sub a() Dim B As Integer Dim C As Integer Dim Ctot As Integer Dim i As Integer, j As Integer B = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row Ctot = 1 For i = 1 To B C = Cells(i, 2).Value For j = 1 To C Cells(Ctot, 3).Value = Cells(i, 1).Value Ctot = Ctot + 1 Next j Next i End Sub
Bookmarks