Forum Discussion
Solved
Groupby or Filter function
Dear Experts, Greetings! I have a data like below(Column A~H) and I want to export it in the format on right side( Column J~W):- Attached is the Worksheet. Br, Anupa...
Maybe use TRANSPOSE instead:
=TRANSPOSE(CHOOSECOLS( B3:H15, 1, 3, 5, 7))
Thanks PeterBartholomew1 , can you please share the groupby solution you were mentioning above.
can we apply it on the below:-
Br,
Anupam
Your question assumes the statistical analysis is complete and you simply need to reformat them.
I was just pointing out the alternative option of performing the statistics in a manner that would output the results you require directly (depending upon the raw data format)
= GROUPBY(group, value, HSTACK(AVERAGE, MEDIAN, MODE),,0)