Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Jan 05, 2026
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...
  • m_tarler's avatar
    Jan 05, 2026

    Maybe use TRANSPOSE instead:

    =TRANSPOSE(CHOOSECOLS( B3:H15, 1, 3, 5, 7))

     

Resources