Multiple Rows (3) to Multiple Columns (3) upon selecting an Item Number

[bcmehta]

Hello,

I have data in rows. For each Item Number there are sets of 3 rows..

When I select the Item Number (drop down), I want the 3 rows data to get populated as 3 columns.

I have about 99 rows of data to convert.

Thanks for any help on this

[wk9128]

Cell B20 formula

Please Login or Register  to view this content.

[Pete_UK]

You can use this formula in cell B20:

=IFERROR(INDEX($B$2:$D$16,MATCH($B$19,$A$2:$A$16,0)+COLUMNS($B:B)-1,ROWS($1:1)),"")

then copy across and down.

Hope this helps.

Pete

[bcmehta]

Thanks but I get the correct value in Cell B20 only. When I paste same formula in the balance 8 cells... I get the same value as B20 which is not the correct value.

[bcmehta]

Thanks a lot Sir. I used the formula in Cell B20 and then copied it across and down (balance 8 cells) and am getting the perfect values. Thanks once again for your kind help.

[wk9128]

@bcmehta You're Welcome. Glad to help . Thank You for the feedback

Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to.
Members tailor answers based on your Excel version. Your profile does not indicate your version.

What I see so far is MS-Off Ver : WIN7 This is the operating system not for OFFICE VERSION

OFFICE 365

Please Login or Register  to view this content.

[bcmehta]

visited this forum after a long gap.... Appreciate your suggestion... Updated my profile ... and Excel Version. Thought, could not find option to change username.

[Pete_UK]

I don't think you can change the username.

Pete