Share via

Filter function that dynamically expands to new columns with different criteria.

Anonymous
2022-09-01T00:01:31+00:00

Hello all,

Is it possible to use an array function to order table 1 into table 2? I would like a formula that if I add different names on first column table 1, it expands automatically.

Table 1

Table 2

I use TRANSPOSE and UNIQUE for the first row and FILTER to complete each column. The criteria to filter is the first cell of each column.

Thanks a lot & regards,

Felipe

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 102K Reputation points Volunteer Moderator
    2022-09-01T23:58:39+00:00

    Hi,

    You may download my solution workbook from here. I have the Query Editor to solve this question. Add data by rows to the blue range and click on Data > Refresh All.

    Hope this helps.

    Was this answer helpful?

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. Anonymous
    2022-09-01T02:08:35+00:00

    Excel 365 Pro Plus with Power Pivot and Power Query.

    Transpose, unique, filter. automate.

    No formulas, no VBA macro.

    Three configurations shown.

    https://www.mediafire.com/file/6q9myca9bu3b56s/08_31_22.xlsx/file

    https://www.mediafire.com/file/5rapb753rwdv1nd/08_31_22.pdf/file

    Was this answer helpful?

    0 comments