Hi ExcelForum Friends,
I have been working with a formula to transpose data from one sheet to another in a different layout.
My raw data holds duplicate values within the data and i can't seem to retrieve these values after the initial entry.
Could anyone give me some guidance on how to resolve this, please see the formula i'm using below.
=IFERROR(INDEX(MERGED!B$2:B$11,MATCH(0,INDEX(--(COUNTIF(B$1:B1,MERGED!B$2:B$11)=4),0),)),"")
If needed i can share a simplified file.
Thanks
Bookmarks