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

Vikas Verma's picture

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