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..
Have you tried the TRANSPOSE function?
Martin
That won't get rid of duplicate items.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
mrice,
I cannot even reacall all the things I have tried...I have honestly tried Index/match, tweaked vlookups, and more to get this to work. I may have had an array formula with a transpose function inside of it at some stage, but nothing I have found and tried, worked..
AligW,
very true also..
Hi
a possible approach: in the second sheet, A1 empty, in B1 and to the right
=IFERROR(INDEX(Sheet1!$A1:$A1000,MATCH(0,INDEX(COUNTIF($A1:A1,Sheet1!$A1:$A1000&""),),0)),"")
Regards
Last edited by canapone; 05-27-2019 at 07:58 AM.
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Hi
same outputs from
=IFERROR(INDEX(Sheet1!$A1:$A1000,AGGREGATE(15,6,ROW($1:$1000)/(COUNTIF($A1:A1,Sheet1!$A1:$A1000&"")=0),1)),"")
Regards
Hi everybody,
Ihave in the meantime found this code, which I did not want as I want a formula really, anyways, it is here
:https://www.mrexcel.com/forum/excel-...olumn-row.html
I will however first try the formulas I just received from canapone, and come back to you. Thank you very much
canapone,
the formula is perfect, thank you very very much!
Ciao,
thanks for sharing your kind feedback.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks