Recomposing data structure in Excel
Posted
by
Velletti
on Super User
See other posts from Super User
or by Velletti
Published on 2012-09-04T10:48:24Z
Indexed on
2012/10/10
21:42 UTC
Read the original article
Hit count: 153
I've got a sheet of 35k rows of the following kind of data that I want to reshape into table below.
So, I want to reshape this data in a way to get all the people within a specific GroupID
in separate columns.
I suppose that I should add a counter for each row within specific group id?
Also, I suppose these kind of issues are a lot more comfortable to be done in databases? Since I often have this kind of data, I need be much quicker about solving it, then I am now.
© Super User or respective owner