Home » Forums » Open Source Learning Center » Question and Answer

Solution How to tranpose 2 column excel spreadsheet by column A group

Vikas Verma's picture
Submitted by Vikas Verma on 21 March, 2014 - 10:34

Hi Dear,

Please try this...

=IFERROR(INDEX($A$2:$A$11,MATCH(0,COUNTIF($D$1:D1,$A$2:$A$11),0),1),"") with CTRL+SHIFT+ENTER

Thanks

Ans.JPG
AttachmentSize
TRANSPOSEQUERY.xlsx11.15 KB
‹ How to tranpose 2 column excel spreadsheet by column A group Save As function ›
»