Hi there, 

I was wondering if there's anyone with an easy solution to use a formula for the following problem. 

I have a list which contains specifications of electronic products which is 4000 rows long and has 53 fields/cells per product. 

On some of these products there are multiple options that I know have in columns but I would like to have on a seperate row in the same column. 

The problem I have is getting all products with extra specifications in rows of the same product. I can do it manuallyy for one product but as I have 4000 products this is going to take forever. I was wondering if someone could help me out with a specific rule that I can apply to the whole document. 

~>> for example, I would like cells C1, C2, C3, C4, C5, C6 from row 2 to go to column C, to R1, R2, R3, R4, R5, R6 and this repeated for some 2800 products without overlapping products

Hope somepne can help me out. 

Thanks in advance

You may consider Power Query Add-in for Excel to for such challenge. If you have Excel 2010, 2013 or Office 365 Professional Plus or Standalone editions, you can install the add-in and try.

I will be glad to help you after you install it and share more details on the problem at hand.

Download the add-in here.

• Edited by Gil RavivMicrosoft employee 19 hours 40 minutes ago

With clear examples and rules, it should be do-able with VBA.  Post sample data -- input and desired output -- for a bunch (maybe 5-10) of your products.  You could use a public site, such as OneDrive, and post the link

Hi Gil, 

Thank you for your reply and help. 

I'll get back to you as soon as I have installed the Add-in

Regards, 

Robert

Hi Ron, 

Thank you too for your feedback. 

I'm going to start with the add-in first and see how well it works for me. 

Your respond is very much appreciated. , 

Regards, 

Robert

You may consider Power Query Add-in for Excel to for such challenge. If you have Excel 2010, 2013 or Office 365 Professional Plus or Standalone editions, you can install the add-in and try.

I will be glad to help you after you install it and share more details on the problem at hand.

Download the add-in here.

• Edited by Gil RavivMicrosoft employee Friday, February 13, 2015 4:13 PM