Any other ways to loop without using VBA?

[mean3]

Hi all,

I have a set of fixed asset data where the categories the fixed asset are only showed at the end of each category (instead of the beginning).
I would need to have the category to be in a new column beside every asset number.
There are over 10,000 rows of asset and 20+ categories combined, so I would prefer not to consider copy pasting or auto filling upwards as an option.
Are there any possible steps + formula to get the categories to be beside each asset number at each row without using VBA?

TIA!

 

[mean3]

Yeap! It's everything above..

 

[jon1315]

So I've used a bit of dummy data in the pic below:



It's kind of the same but in reverse:
1 - go to the bottom and type the last FA category (as I have in the image)

in the cell above, type the formula as I have in the image

Drag the formula up

 

[jon1315]

You may need to play around with the references in the formula as I don't know the last row of your data

 

[mean3]

YES! Got it exactly like how I wanted it now. thank you so much! saves me so much time. Thank you! :D

 

[jon1315]

Brill - glad I could help!