Book1.xlsx
I have data (much more than below) in two columns as you can see below.
15 χ
17 χ
23 χ
30 Υ
31 Υ
45 Ζ
47 Ζ
How can I put automatically data under category X Y Z in three different columns as you can see below?
χ Υ Ζ
15 30 45
17 31 47
23
As I have mentioned above there are a big number of data and it is not possible to do it manually
I would like to put data as you can see in columns D, E, F in the attached file. Is it possible to do it automatically.
Thanks in advance.
Easiest with Pivot table approach
Never use Merged Cells in Excel
it is not correct with pivot table. If you see the data which belong to age are 232 (count=232) and the pivot table gives 192 (count=192) . I do not know why but there is a difference. Something wrong and strange for me. The same happens with all other data of death and disabled.
Some are duplicated.
if you put COUNT instead of MAX in Pivot Table then you'll see how much of every number in that row is in it.
Some are duplicated.
if you put COUNT instead of MAX in Pivot Table then you'll see how much of every number in that row is in it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks