hi please if someone can help me, I want to trasform table to list see the attacment.
table-to-list.xlsx
hi please if someone can help me, I want to trasform table to list see the attacment.
table-to-list.xlsx
=INDEX(A$2:A$7,ROUNDUP(ROW(A1)/COUNTA($B$1:$G$1),0))&" " &INDEX($B$1:$G$1,IF(MOD(ROW(A1),COUNTA($A$2:$A$7))=0,6,(MOD(ROW(A1),COUNTA($A$2:$A$7)))))
in I2
and
=OFFSET($A$1,ROUNDUP(ROW(A1)/COUNTA($B$1:$G$1),0),IF(MOD(ROW(A1),COUNTA($A$2:$A$7))=0,6,(MOD(ROW(A1),COUNTA($A$2:$A$7)))))
in J2
then copy down.
Probably a better way but I think it works.
Please see attached file.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
ragulduy
It works like a charm.
Thank you very very much.
AlKey
Thank you very much for the second option.![]()
Last edited by gxatzis30; 05-28-2014 at 09:57 AM.
Appreciate your feedback!![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks