Excel Database Help needed Urgently!

[jhobbsy89]

Hi all,

This is my fist post. I am currently doing some work which is with a large database of products and I am stuck!
Below is a screenshot of the sheet.

How do I go about this problem?

Urgent help would be appreciated! Thanks in advance

Current:
abc1;abc2;abc3	random text 1	100	200	300
xyz1;xyz2;xyz3	random text 2	900	800	700
Desired:
abc1	random text 1	100	200	300
abc2	random text 1	100	200	300
abc3	random text 1	100	200	300
xyz1	random text 2	900	800	700
xyz2	random text 2	900	800	700
xyz3	random text 2	900	800	700

<tbody>
</tbody>

 

[jim may]

Welcome to the Mr. Excel Site jhobbsy89.

I would go the VBA (code) route to get your solution. Are you opposed to or prevented from using
VBA Code?

Jim

 

[jhobbsy89]

I'm not opposed to anything that can help. Can you point me in the right direction?

Thanks

 

[jim may]

A VBA (code) solution would use the VBA Function "Split" (which converts your Column A data to an Array), and then loops thru your data and posts using the Cells() function to place your output in the layout form you want.

Good Luck,

Jim

 

[jim may]

Were you able to solve your problem...??? I just did after a day, or 2 (off and on it)... LOL

Reply If you would like to see my code solution? -- Jim