Data Representation

[aks_npti]

Hi Guys ,

Need your help!!!!

I have a huge spreadsheet(25000+ records ) which is arranged as below:



However this data need to be re-arranged in below pattern. The blank cells will have the amount for the respective id & group.



Is V lookup using Index/Match is the way out ???

Regards,
Aks

 

[Somendra Misra]

Hi aks_npti,

Pivot table can solve your purpose, and it will be fast too. See the attached file.
If you insist on formula solution, try searching transpose data from row to column or transpose data or visit below link.

http://chandoo.org/forum/threads/formula-to-change-vertical-items-to-horizontal-items.16619/

Regards,

 

[aks_npti]

Thanks a lot SM for the quick response!!!!!!!!!