Hello.
I have a list of values. There are three columns and almost hundred rows. The columns are labeled simply 3, 5, and 7. There are random values on the first column; for simplicity, I used a,b,c,d... Also, there are prices within the table. It looks similar to this:
1 2 3
a 10 20 30
b 40 50 60
c 70 80 90
d 100 110 120
e 130 140 150
f 160 170 180
g 190 200 210
My problem is that I need to allign all these values in two columns. The first column would read a1, a2, a3, b1, b2, b3, c1,c2,c3... and the second column would read the respective value, i.e., 10, 20,30, etc. So, what I need looks like this:
a1 10
a2 20
a3 30
b1 40
b2 50
b3 60
c1 70
c2 80
c3 90
d1 100
d2 110
d3 120
e1 130
e2 140
e3 150
f1 160
f2 170
f3 180
g1 190
g2 200
g3 210
Can anybody help me?
Thank you for your help.
I have a list of values. There are three columns and almost hundred rows. The columns are labeled simply 3, 5, and 7. There are random values on the first column; for simplicity, I used a,b,c,d... Also, there are prices within the table. It looks similar to this:
1 2 3
a 10 20 30
b 40 50 60
c 70 80 90
d 100 110 120
e 130 140 150
f 160 170 180
g 190 200 210
My problem is that I need to allign all these values in two columns. The first column would read a1, a2, a3, b1, b2, b3, c1,c2,c3... and the second column would read the respective value, i.e., 10, 20,30, etc. So, what I need looks like this:
a1 10
a2 20
a3 30
b1 40
b2 50
b3 60
c1 70
c2 80
c3 90
d1 100
d2 110
d3 120
e1 130
e2 140
e3 150
f1 160
f2 170
f3 180
g1 190
g2 200
g3 210
Can anybody help me?
Thank you for your help.