Here in the below video, i have explained a simple formula of excel about how can we convert all data from one column to multiple columns based on the Party’s Name, Contact No. and Address of Party.
Here i have used a simple formula and used Find and Replace Command to do the task in a simple way. so have a look at the video to learn and find the download button below to download the sample excel file for it.
Video Tutorial
Download Project File for Practice (.xlsx)
