hi good people,
i have been spending time and more time looking for a formula that will take text from a vertical dynamic list and transpose it horizontally in another sheet as headers. if the list in sheet1 either extends or shrinks, the horizontal list in sheet2 must also update. the list in sheet1 contains many duplicate text values. please help me, thank you kindly..
Bookmarks