Need help with a formula!

**rebecca1980** · 03-06-2015, 01:03 PM

Wondering if anyone can help me troubleshoot this problem and if there is a formula to solve?

For customer records I have a sheet with one row detailing purchase data, but if the customer ordered more than one product, the additional products are displayed in subsequent rows rather than on the same row in individual cells. So, an order record might have several rows attached to it depending on how many items were purchased. I have deleted all the duplicate email addresses for the purchase except for in the first row. Now I want to add a bunch of blank columns where I can put line items into. I want a formula that says IF "X" cell is blank (i.e. the email address field for the additional line item rows), then contents of "Y" cell (which would be the extra row with a line item beneath the original row) need to go in "XX" cell (which will be the cell in the next column over from the first line item in the original row with purchase data. My goal is to get all items purchased onto one row.

**mcmahobt** · 03-06-2015, 01:06 PM

Can you upload a sample workbook showing how your data is setup?

**rebecca1980** · 03-06-2015, 01:21 PM

example-workbook.xlsx

Yes! So in this example, I want The line items in column E to go to the first row of the order so there is only one row per customer record.

My original thought would be something like IF B3 is blank, then F2 should = E3. I have no idea if that would work. Troubleshooting.

**mcmahobt** · 03-06-2015, 01:29 PM

Could you make a quick addition of what you are hoping to achieve in terms of results to your workbook?

**rebecca1980** · 03-06-2015, 01:35 PM

example-workbook-2.xlsx

Sure! This attachment will show what I'm hoping my data will eventually look like. This way I can delete the rows without item data and work with the actual data in individual rows.