Complicated unpivot

[PhillipB]

I have a set of data that needs to take several columns bring them all in to one column but also then to copy the data from the other columns that they match and copy it down.

The data initially reads like this:

Date 1

Date 2

Date 3

XX234

XX235

XX236

XX279

21/11/2022

22/11/2022

23/11/2022

XY236

XZ235

YX236

XT279

22/11/2022

26/11/2022

31/11/2022

XB234

XB235

XX238

XV279

21/11/2022

24/11/2022

25/11/2022

RX244

RX235

YX236

PX279

22/11/2022

23/11/2022

23/11/2022

And it needs to ready like this

		Date 1		Date 2		Date 3
XX234		21/11/2022		22/11/2022		23/11/2022
XY236		22/11/2022		26/11/2022		31/11/2022
XB234		21/11/2022		24/11/2022		25/11/2022
RX244		22/11/2022		23/11/2022		23/11/2022
XX235		21/11/2022		22/11/2022		23/11/2022
XZ235		22/11/2022		26/11/2022		31/11/2022
XB235		21/11/2022		24/11/2022		25/11/2022
RX235		22/11/2022		23/11/2022		23/11/2022
XX236		21/11/2022		22/11/2022		23/11/2022
YX236		22/11/2022		26/11/2022		31/11/2022
XX238		21/11/2022		24/11/2022		25/11/2022
YX236		22/11/2022		23/11/2022		23/11/2022
XX279		21/11/2022		22/11/2022		23/11/2022
XT279		22/11/2022		26/11/2022		31/11/2022
XV279		21/11/2022		24/11/2022		25/11/2022
PX279		22/11/2022		23/11/2022		23/11/2022

Column 2-4 is moved down sequentially with the dates information then also copied down in to the columns to maintain the relationship. 

[PhillipB]

Thanks for the help

[ddpl · Accepted solution]

@PhillipB try "unpivot only selected column"as per below