Transpose from Rows to Columns

[mhedge]

Hi,

I have a list of parts pand families that are duplicated in rows (left data). Would anyone have a formula or method to transpose that list to columns (right data).?

Thank you.



PART C_FAM PART C_FAM
0WF64TX7AA JT 0WF64TX7AA JT RT RT BQ M4 BV BQ M4 M7 BV
0WF64TX7AA RT
0WF64TX7AA RT
0WF64TX7AA BQ
0WF64TX7AA M4
0WF64TX7AA BV
0WF64TX7AA BQ
0WF64TX7AA M4
0WF64TX7AA M7
0WF64TX7AA BV

[ben_hensel]

Select the range of data you want to move. B2:B10 in the example.
Ctrl+C to copy to the clipboard.
Rightclick on the leftmost cell in the range you want to move them to (eg F2), launching the tooltip.
From the tooltip menu, under under "Paste Options", select the fourth option (Transpose).



The TRANSPOSE function (entered as an array on a range) can accomplish basically the same thing formulaically.

[alansidman]

This can be accomplished with a couple of quick key strokes in Power Query.

Please Login or Register  to view this content.