Forum Discussion
Duplicate Formula with Multiple Data Cells
Hi, I'm looking to use a formula to transfer information from several columns to another table. The problem i'm having is i'm trying to transfer multiple rows with the same value. I.e. I want eac...
You can also convert your data to Excel tables and it becomes dynamic ( the more rows are added or removed, the output will expand and collapse) Sergei has provided you with a solution with formula. The same result can be achieved using power query which is dynamic with Excel tables.
attached is a quick video on how to do this using Power Query.