User Profile
CBay88
Copper Contributor
Joined Mar 13, 2023
User Widgets
Recent Discussions
Re: Excel Formula for combining data into a single row
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.Re: 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.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 broken up into different tabs. I need all of the info on one spreadsheet, which I could normally do in just a few minutes. HOWEVER, there are two tabs that will list the individual "X" number of times based on.... per item purchased (i.e. package #1, #3, #5, #8 - this person would be listed 4 times) per answer to a custom question (i.e. address, city, state, zip, phone, email - this person would be listed 6 times) Each registration is different, depending on purchases and completed info to the custom questions. I just need everything listed on one row per registrant. Is there a way to do this so I don't have to re-enter everything manually? TIA
