Forum Discussion
Excel Formula for combining data into a single row
I am using an online registration platform for an event where people can select one or several items to purchase with their registration. When I download the information (Excel format), the info is ...
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.