0
I need to convert data in excel from e.g.
colour red blue green
fruit apple orange banana
to
colour red
colour blue
colour green
fruit apple
fruit orange
fruit banana
ew318
Posted 2017-07-18T15:43:47.480
Reputation: 1
Excel: convert data from rows to columns
3
try the methods described here: https://stackoverflow.com/questions/20541905/convert-matrix-to-3-column-table-reverse-pivot-unpivot-flatten-normal
– Scott Craner – 2017-07-18T15:45:36.367If you have Excel 2010+, you can use
Power Query, a free Microsoft add-in for 2010-13; orData-->Get & Transform, a part of Excel 2016, to easily do the unpivoting. – Ron Rosenfeld – 2017-07-18T20:45:10.627