troubleshooting Question

Rework Excel Table

Avatar of stryker11
stryker11 asked on
Microsoft OfficeMicrosoft ExcelMicrosoft Access
4 Comments1 Solution362 ViewsLast Modified:
Dear Experts

I have a Table as shown below.  

Combination 1                                                
Table A      Table B      Table C      Table D      Table E      Table F       Table G      Table H      Table J
1      10      19      28      37      46      55      64      73
2      11      20      29      38      47      56      65      74
3      12      21      30      39      48      57      66      75
4      13      22      31      40      49      58      67      76
5      14      23      32      41      50      59      68      77
6      15      24      33      42      51      60      69      78
7      16      25      34      43      52      61      70      79
8      17      26      35      44      53      62      71      80
9      18      27      36      45      54      63      72      81


There are 81 people seated in "tables" numbered A to J on a combination called Comb1. There are 10 combinations in Total. I need to manipukate the table to show like as below:

Person      Comb11     Comb2 ....Comb 10
1                 Table A      Table B      Table C
2
3
.
.
81

Can this be done in Excel or Access?  Any help in this matter will be greatly appreciated.

Thanks

Anand
Sample-Combination.xlsx
ASKER CERTIFIED SOLUTION
redmondb

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros