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))
Hi anupambit1797!
You can use this formula:
=VSTACK(TOROW(A2:A15&""),HSTACK(TOCOL(A1:G1,1),WRAPCOLS(TOCOL(--B3:H15,2),4)))Blessings!