Hello,
I have data in the following format:
I would like to get it into the following format:
Is there a command or set of commands that can efficiently accomplish this task? I have played around with reshape and xpose but to no avail. Thank you for any guidance,
James
I have data in the following format:
PLACE | GROUP_A | GROUP_B | GROUP_C |
Y | 100 | 105 | 102 |
Z | 300 | 312 | 319 |
I would like to get it into the following format:
PLACE | GROUP | COUNT |
Y | A | 100 |
Y | B | 105 |
Y | C | 102 |
Z | A | 300 |
Z | B | 312 |
Z | C | 319 |
Is there a command or set of commands that can efficiently accomplish this task? I have played around with reshape and xpose but to no avail. Thank you for any guidance,
James
Comment