Transforming Vertical Data to Horizontal Format in Excel

[Masond3]

Hi Team,

I have an Excel file that contains the following columns:

• Id (Column A)
• BMW (Column B)
• Porsche (Column C)

In Columns B and C, the business has populated each cell with either a value of (A) or (R). (There are also Records which have no value populated)

Example Data 

ID	BMW	Porsche
11111	A
22222		A
33333	A	A
44444	R
55555		R
66666	R	R
77777

I would like to transform this data from a vertical to a horizontal format.

Desired output 

Id	Outcome
11111	BMW - A
22222	Porsche - A
33333	BMW - A
33333	Porsche - A
44444	BMW - R
55555	Porsche - R
66666	BMW - R
66666	Porsche - R

Looking forward to your assistance 

Regards

[Deano478 · Accepted solution]

hey @Masond3 have a look at the attached WF

[Masond3]

@Deano478  You are amazing! Such a simple yet effective solution.