Forum Discussion
Insert a group of rows (copy) from one tab into another tab based on a cell value
Dear experts, Please put me out of my misery. After a long process of pulling data from a PDF to put into Excel, I now have 2 tabs of data. It was beautiful and served the purposes initially explai...
=DROP(IFNA(REDUCE("",SEQUENCE(ROWS(A3:A5)),LAMBDA(u,v,VSTACK(u,"Office "&INDEX(A3:A5,v),HSTACK("Asset Set","Asset","Description","Delivery Date","Delivered?"),FILTER(A9:E14,A9:A14=INDEX(B3:B5,v))))),""),1)
With Office 365 or Excel for the web you can apply this formula.
Thanks it very helpful.
