Massive Spreadsheet... need help with

I have a spreadsheet that has a many part #'s, and for each part # it has up to 250 variants. With each variant #, I also need to display a variant name. Right now they are listed vertically, in columns, but I am doing a data merge in InDesign, so I need for each part # and all the variants#'s, variant names, as well as a blank cell for a bar code # to be displayed. This spreadsheet is going to be like... over 1,000 columns wide.

Does anybody know how to take data that is set up in columns and move it over to rows, as well as to insert a blank cell in between each set...

so it is now like.
a b c d
1 Item Variant Description Bar code #
2 942- 1001 Bright White
3 942- 1002 Soft White
4 942- 1003 Black

and I need it set-up like

a b c d e f g
1 Item V1# V1D BC#1 V2# V2D BC#2
2 942- 1001 bright white 1002 Soft White

Hope this makes sense

Can anybody help me with this???

Thank you!!!!

Please keep in mind that I do not know macros... but any assistance would be basically saving my life, and my deadline.

Allene

Lets see a sample workbook, with the original set up and the desired result....

Try the attached, which is a solution using formulae.

In cell F16 the maximum number of columns should of course be the number shown times 3, since there are 3 columns for every variant.

hth.

Regards
Mike

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.