Excel question - Transposing cells

[GSXRMovistar]

Hi all, quick Excel question. I have a large dataset where the data is arranged as such:-

ROW 1 : UniqueItemA, SubValue1, SubValue2, SubValue3
ROW 2 : UniqueItemB, SubValue1, SubValue2, SubValue3

Which I need transposed into the following layout:-

ROW 1 : UniqueItemA, SubValue1
ROW 2 : UniqueItemA, SubValue2
ROW 3 : UniqueItemA, SubValue3
ROW 4 : UniqueItemB, SubValue1
ROW 5 : UniqueItemB, SubValue2
ROW 6 : UniqueItemB, SubValue3

I've tried a few things including pivots but no joy as yet. Any simple/quick way of doing this as I'd prefer not to hire someone to manually slog through it.

Thanks.

 

[GSXRMovistar]

Yeah always 3 sub values. I thought about Macros but not sure how to approach, key logging navigation seems very hit and miss and I need to process ~10k rows.

 

[GSXRMovistar]

You know that makes logical sense, will give it a bash in the morning when back onsite.

Thanks.

EDIT: Just tried it on some sample data, yep works perfectly, such a simple solution. Knew it would be worth me asking.