Column to row based on conditions

Hi Experts,

Please find the attached excel and help me to copy the records as shown in rows.




Thanks
Ravi

Hi Ravi,

Welcome to the Forum.

This can be done simply using a Pivot Table - please see attached.

Regards

peterrc

Hi,

Try the following formula (array entered - confirmed by CTRL+SHIFT+ENTER)

In K2:
{=IFERROR(INDEX($C$1:$C$11,MATCH($J2&K$1,$A$1:$A$11&$B$1:$B$11,0)),"")}

Hi Peterrc,

I have more than 20000 records. The values of third column are showing as 1, in all cells.


Thanks
Ravi

Petercc...
Its working

Thank you.

Hi Ravi,

Glad to help and thanks for the feedback.
When you get chance can you please mark your thread as SOLVED.

Thanks

Regards

peterrc