Forum Discussion
Solved
combine data
I wish to combine rows of data linking unique email addresses to all the row/seat numbers associated with that address. (Note: I separately combined the row and seat columns with a formula, but I am ...
- Thanks so much Oliver. Copying the data and pasting it in the blue table and refreshing the green table works great!
Randy, you are welcome. I've just read your reply from your first discussion where you say that you're working with Excel 2016. If you still work with Excel 2016 then the suggested formulas don't work because functions such as LET and LAMBDA are only supported in the latest versions of Excel which are Office 365 and Excel for the web.
Alternatively you can use Power Query with Excel 2016. In the attached file you can add data to the blue dynamic table. Actually you can copy all your data and paste it in the blue dynamic table of the sample file. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
Thanks so much Oliver. Copying the data and pasting it in the blue table and refreshing the green table works great!