Need help in pivot unpivot the data

I have an excel data like below id value text U1 abc North U1 fgh Up U1 jse In U2 abc South U2 fgh Down U2 jse Out U2 fjg 1 U2 qwo 2   which need to...