Excel Unusual Label Sequence in Excel 2010

[OJones]

Hi,
I've been trying to figure this out for the past day and I'm not getting anywhere. What I need is a series that goes....

P1 C P1 180 P1 12000 P1 1/10 P1 GY

P2 C P2 180 P2 12000 P2 1/10 P1 GY

P3 C P2 180 P3 12000 P3 1/10 P3 GY

etc.

Is there anyway of automating this as I need thousands of these? Thanks for your time.

 

[alow]

It it going to continually increase like that? Or is there some repetition to it?

 

[OJones]

It it going to continually increase like that? Or is there some repetition to it?

Hi alow,

Yes, it going to continue in +1 increments. I'm going to need to do almost a thousand a day, so doing it manually would be a time sink.

 

[alow]

Can you give a longer example of the pattern you're looking for? or a description? eg:

Column 1: Increase by 1 every row
Column 2: Increase by 1 every 2 rows
Column 3: Increase by 1 every row

Etc.. I think there is something to do to make this easier for you, I just want to make sure I fully understand before I go on one of my long rants of how to do the wrong thing.

 

[OJones]

Can you give a longer example of the pattern you're looking for? or a description? eg:

Column 1: Increase by 1 every row
Column 2: Increase by 1 every 2 rows
Column 3: Increase by 1 every row

Etc.. I think there is something to do to make this easier for you, I just want to make sure I fully understand before I go on one of my long rants of how to do the wrong thing.

It's 6 columns in total.

P* C, P* 180, P* 12600, P* 1/10, P* 1/100, P* GY

Where * = 1 for the first row and increments +1 after that, so it's be...


P1 C, P1 180, P1 12600, P1 1/10, P1 1/100, P1 GY


P2 C, P2 180, P2 12600, P2 1/10, P2 1/100, P2 GY


P3 C, P3 180, P3 12600, P3 1/10, P3 1/100, P3 GY


P4 C, P4 180, P4 12600, P4 1/10, P4 1/100, P4 GY



I hope I've made that clear. Thanks for the interest alow.

 

[alow]

I think I have it now. What you would do for the first column is the following:

="P"&ROW(A1)&" C"
Column 2:
="P"&ROW(A1)&" 180"
Column 3:
="P"&ROW(A1)&" 12600"
Column 4:
="P"&ROW(A1)&" 1/10"
Column 5:
="P"&ROW(A1)&" 1/100"
Column 6:
="P"&ROW(A1)&" GY"

You would put those each in the first cell of the respective columns. Then you can highlight all six cells and use the fill handle (The bottom right hand corner of the selected cells) to click and drag that formula down as far as you want. The number after P should start at 1 and increment by 1 for every row. Let me know if that does it for you!

 

[alow]

Have you had a chance to try this out?

 

[Kevin@Radstock]

Just to take it one further, in B1:

="P"&ROW(A1)&" C, P"&ROW(A1)&" 180, P"&ROW(A1)&" 12600, P"&ROW(A1)&" 1/10, P"&ROW(A1)&" 1/100, P"&ROW(A1)&" GY"

Copy down as far as required, copy as values, delete column A