Generate Quarter with extra values

[sujit_nath]

 have a column Quarter containing values Q1,Q2,Q3 and Q4.

I want to generate a column TempQuarter in script such that the values are connected as -

Quarter	TempQuarter
Q1	Q1
Q1	Q1 Actual
Q1	Q1 Plan
Q2	Q2
Q2	Q2 Actual
Q2	Q2 Plan
Q3	Q3
Q3	Q3 Actual
-------- and so on till Q4	-------- and so on till Q4

[sujit_nath · Accepted solution]

 got an answer to this. Initially left join was not working as the former quarter values had trailing spaces.