Data Restructuring, Tranposing

Question

Hi Folks,

I am trying to transpose a dataset, however I am stuck and running out of ideas.  Would be great if you can provide some support.

Situation:

There are few customers who are buying products and we have the product name, product segment, client product match, contract status along with the start and end date. Now one customer is buying from different vendors.

Right now the data is collected in such a way that a customers unique ID is in multiple rows (Since they are buying from multiple vendors). I want one customer entry and we can have vendors and other details in different columns.

I know this is not easy to explain. Attaching the reference input and expected output file.

Thanks in anticipation.

Regards

G

Output.xlsx

Input.xlsx

binu_acs · Accepted Answer

@gmamtani One way of doing this with the batch macro

Yoshiro_Fujimori · Accepted Answer

Hi @gmamtani ,

Here is another way of doing this.

Workflow

Output
You may change the column order as necessary.

Personally, I feel the input data format is more effective to deal with, as it is more "normalized" than the output data format.

But I also understand sometime it is required to do this.

Good luck.