Using Arrange to organize data

[Adam_B]

Hello, 

I have a data set, see attached.  I need to have 4 lines per supplier name, each populated with the associated MEETING in the respective QTR.  I know I should use the Arrange function but I can't get there.  Would like some help. 

Thank you, 

Adam

[binuacs]

@Adam_B can you upload the expected output result?

[Adam_B]

@binuacs Thank you for the reply.  

Here is an example, 

Original Data:

Year	Supplier Name	Meeting Q1	Meeting Q2	Meeting Q3	Meeting Q4
2019	STAPLES	1	0	1	1

Expected outcome:

Year	Supplier Name	Meeting Q1	Meeting Q2	Meeting Q3	Meeting Q4
2019	STAPLES	1	0	0	0
2019	STAPLES	0	0	1	0
2019	STAPLES	0	0	0	1
2019	STAPLES	0	0	0	0

[Qiu]

@Adam_B 
I hope there is a better solution.

This one might a bit lengthy. 😂

[Prometheus]

@Adam_B Here's another solution.

 

 

[Adam_B]

Is it easier to get the data to look like this? 

Year	QTR	Supplier Name	Meeting
2019	1	STAPLES	1
2019	2	STAPLES	0
2019	3	STAPLES	1
2019	4	STAPLES	1

[binuacs]

@Adam_B 

[Adam_B]

@binuacs I have data that looks like this right now:

Year	Supplier Name	Q1	Q2	Q3	Q4
2018	STAPLES	0	0	0	0
2019	STAPLES	1	1	0	0
2020	STAPLES	1	0	0	1
2021	STAPLES	0	1	1	1

I need to transpose it and create data to look like this:

Year	QTR	Supplier Name	Meeting
2018	1	STAPLES	0
2018	2	STAPLES	0
2018	3	STAPLES	0
2018	4	STAPLES	0
2019	1	STAPLES	1
2019	2	STAPLES	0
2019	3	STAPLES	1
2019	4	STAPLES	1
2020	1	STAPLES	1
2020	2	STAPLES	0
2020	3	STAPLES	0
2020	4	STAPLES	0
2021	1	STAPLES	0
2021	2	STAPLES	1
2021	3	STAPLES	1
2021	4	STAPLES	1

Thank you 

Adam 

[binuacs · Accepted solution]

@Adam_B use can use the same workflow in your input

[Adam_B]

@binuacs Thank you!