Soldato
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.
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.