Convert Row/Column data to Database


A

Aviaro

Is there any easy method of converting/transposing the data in columns a-c
and rows 1-3 in the first section below to the database setup in the second
setion. The example here can be done manually in a few seconds but this would
not be possible when dealing with over 100 rows and over 13 columns?

a b c
1 10 40 70
2 20 50 80
3 30 60 90

1 a 10
2 a 20
3 a 30
1 b 40
2 b 50
3 b 60
1 c 70
2 c 80
3 c 90

Thanks
 
Ad

Advertisements

A

Aviaro

Thank you "smartin", that was brilliant, your solution has solved an issue
which had no remedy locally. I would never have come up with the use of
functions "index", "counta" & "mod" for the solution.
Aviaro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top