Forum Discussion
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,
Anupam
Maybe use TRANSPOSE instead:
=TRANSPOSE(CHOOSECOLS( B3:H15, 1, 3, 5, 7))
7 Replies
Slightly more complicated
= LET( pairs, WRAPROWS(TOCOL(data), 2), values, DROP(pairs,,1), WRAPCOLS(values, 4) )It would also be possible to delete the table and work directly from the source data using GROUPBY along with the rather large array of statistical functions.
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)
Maybe use TRANSPOSE instead:
=TRANSPOSE(CHOOSECOLS( B3:H15, 1, 3, 5, 7))Hi anupambit1797 !
Try this formula:
=VSTACK(TOROW(A2:A15&""),HSTACK(TOCOL(A1:G1,1),WRAPCOLS(TOCOL(--B3:H15,2),4)))Blessings!
Hi anupambit1797!
You can use this formula:=VSTACK(TOROW(A2:A15&""),HSTACK(TOCOL(A1:G1,1),WRAPCOLS(TOCOL(--B3:H15,2),4)))Blessings!
