Formula / Macro Help for Populating data and pulling in data

[crewe2004]

Hi

Im new to Excel Forums so please be gentle with me

I need some help

I have some research that i have been doing for work and have just been informed by the developers that they need the data in a certain format. For example i have researched the price of a beer like Budweiser from 6 supermarkets. I have put the SKU ''Budweiser'' in Cell A2 and have have put the web links to this product from the supermarkets in cells B2, C2, D2, E2, F2 and E2.

The developers need the research to go in all the same column. I.e. Cells A1 to A6 would be say ''Budweiser'' but the web links need to go in B1 to B6. I would then have to put the same for ''Heineken'' in cells A7 to A12 and have its corresponding web links in cells B7 to B12. This order would be the same for all the products. I.e. another 6 cells in Column A & B for another product

I need to do this for about 1,300 different products.

I only know the basics of Excel, so please any help would be really appreciated!!

If required i can attach an example, incase im not explaining it very well

 

[sheetspread]

Use the reverse pivot table

https://www.youtube.com/watch?v=xmqTN0X-AgY

 

[crewe2004]

Thanks for such a prompt reply. That worked!!

Last bit of help needed please

At the minute it lines up with A1 to A6 ''Budweiser'' and A7 to A12 ''Heineken''. Basically every 6 cells a different product.

I have just been told it needs to display the following for cells A1 to A6:[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]

[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]SKU_A
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]SKU_A
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]SKU_A
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]SKU_A
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]SKU_A
[TABLE="width: 64"]
<tbody>[TR]
[TD="width: 64"]SKU_A[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[/TR]
</tbody>[/TABLE]

with the same for cells A7 to A12 but with ''SKU_B'' and it changing every 6 cells with a different letter.

Is there a formula or macro that can do this automatically for me for all 1,300 products with it changing the corresponding letter after each 6 cells?

Hope that makes sense

Thanks
Tom

 

[sheetspread]

Excel 2010
	A
1	SKU_A
2	SKU_A
3	SKU_A
4	SKU_A
5	SKU_A
6	SKU_A
7	SKU_B
8	SKU_B
9	SKU_B
10	SKU_B
11	SKU_B
12	SKU_B
13	SKU_C
14	SKU_C
15	SKU_C
16	SKU_C
17	SKU_C
18	SKU_C
19	SKU_D
20	SKU_D
21	SKU_D
22	SKU_D
23	SKU_D
24	SKU_D
Sheet8

Cell Formulas
Range	Formula
A1	="SKU_"&MID("ABCDEF",INT(ROW(A6)/6),1)

Wait that won't work, does it go ABCDEF then repeat ABCDEF, etc or are there additional letters?

 

[crewe2004]

Thanks for prompt reply

There will be additinal letters. So will be:

ABCDEFG.... all the way to Z.

When it gets to Z, i need it to do double AA, BB, CC

If that makes sense!

 

[sheetspread]

Ok thats actually easier:

Excel 2010
	A
1	SKU_A
2	SKU_A
3	SKU_A
4	SKU_A
5	SKU_A
6	SKU_A
7	SKU_B
8	SKU_B
9	SKU_B
10	SKU_B
11	SKU_B
12	SKU_B
13	SKU_C
14	SKU_C
15	SKU_C
16	SKU_C
17	SKU_C
18	SKU_C
19	SKU_D
20	SKU_D
21	SKU_D
22	SKU_D
23	SKU_D
24	SKU_D
Sheet8

Cell Formulas
Range	Formula
A1	="SKU_"&SUBSTITUTE(ADDRESS(1,INT(ROW(A6)/6),4),1,"")

Wait double letters, not AA, AB, AC but AA,BB,CC,DD...........AAA,BBB,CCC?

 

[crewe2004]

Thank you so much!

Nope your way was correct

Your a legend. I know where im going if i need help in the future