S
SonnyBubba
I am trying to regroup how my data is arranged on the spreadsheet.
I work in the cellular phone industry, and have a spreadsheet with data for
our towers. Each tower has several radios, and each radio has a channel. My
spreadsheet currently has one row per channel, and I want to make it into one
row per tower.
Example:
Spreadsheet I have:
Headings: Tower, Radio, Channel
1,1,500
1,2,406
1,3,504
2,1,300
2,2,150
3,1,523
3,2,498
3,3,671
3,4,140
4,1,100
Sheet I'm trying to create:
Tower, Channel1, Channel 2, Channel 3, Channel 4
1,500,406,504
2,300,150
3,523,498,671,140
4,100
I work in the cellular phone industry, and have a spreadsheet with data for
our towers. Each tower has several radios, and each radio has a channel. My
spreadsheet currently has one row per channel, and I want to make it into one
row per tower.
Example:
Spreadsheet I have:
Headings: Tower, Radio, Channel
1,1,500
1,2,406
1,3,504
2,1,300
2,2,150
3,1,523
3,2,498
3,3,671
3,4,140
4,1,100
Sheet I'm trying to create:
Tower, Channel1, Channel 2, Channel 3, Channel 4
1,500,406,504
2,300,150
3,523,498,671,140
4,100