LinkBack URL
About LinkBacks
I had attached my worksheet in which "original" sheet refers to the data available & the "required format" sheet refers to the output required for me.
Please help me to solve this.
Regards,
Suresh
I had attached my worksheet in which "original" sheet refers to the data available & the "required format" sheet refers to the output required for me.
Please help me to solve this.
Regards,
Suresh
Welcome to the board.
In B2 and copy right and down,
=INDEX(Original!$B$2:$C$28, MATCH('Required format'!$A2, Original!$A$2:$A$28, 0), MATCH('Required format'!B$1, Original!$C$2:$C$28, 0))
Entia non sunt multiplicanda sine necessitate
It is not working. Pl suggest another.
Pl refer the attached file with formulas.
Last edited by mechksbabu; 09-29-2016 at 11:47 PM. Reason: Attachment missed
Hello,
The easiest way is to use the Power Query (using the option column pivot)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks