Forum Discussion
Excel Formula for combining data into a single row
OliverScheurich Sorry, but I'm not sure I am following this correctly. I thought it would have to be some sort of if/and statement with a vlookup???? Here is an example of the what I'm trying to organize. This tab lists the individual multiple times....one for each purchase they've made. But I want all of the info per person on one row. I hope that makes sense.
In the previous suggestion i tried to make up a scenario with two tabs each with several information for each registrant. Unfortunately i misunderstood what you want to do.
For your actual data you can try Power Query. Does the green result table show the expected result?
In the attached file you can add data to the blue dynamic table. 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.
The data layout in the screenshot and in the attached file is for illustration. You can place the green result table in another worksheet as well.
- Wow...okay, I'm starting to think this is well beyond my level of understanding and ability. I see the data updating, but I can't tell how you did that. I think I may just have to settle for manual entry. Thank you for helping...this really would be a great tool if I were able to wrap my head around the steps.