Convert last columns to rows

Asked Dec 12 '17 at 14:16

Active Dec 12 '17 at 14:16

Viewed 34 times

My data look like the below

Rauf    11/12/2017   635  1240  1430  1630
Rauf    12/12/2017   630  1230  1430  1630

From Excel, I want to get the data as follows,

Rauf    11/12/2017  635
Rauf    11/12/2017  1240
Rauf    11/12/2017  1430
Rauf    11/12/2017  1630
Rauf    12/12/2017  630
Rauf    12/12/2017  1230
Rauf    12/12/2017  1430
Rauf    11/12/2017  1630

asked Dec 12 '17 at 14:16

Rauf

3,627
10
26
37

Thanks for sharing. [What have you tried](https://mattgemmell.com/what-have-you-tried/)? – Dave Dec 12 '17 at 14:16
check out the second answer here: https://stackoverflow.com/questions/20541905/convert-matrix-to-3-column-table-reverse-pivot-unpivot-flatten-normal – Scott Craner Dec 12 '17 at 14:17

Convert last columns to rows

0 Answers0