How do I put data into a reference table?

BigBonna

New Member
Joined
Jan 27, 2014
Messages
20
What I want to do is make the following raw data display in a table like the one below, however I am not proficient enough at Excel to make that happen myself. Would any of you guys be willing to lend a hand?

I hope my example makes it clear. I would like the data to be represented in table, ideally each name having its own cell inserted (if that's possible) at its reference point. I would also like each person's favourite colour to be added next to their name in the reference table (not for the cell to be coloured in).

I've used silly examples just to make it simple to work with for now. I'd like to attempt to put the real thing together myself eventually. I just need to be pointed in the right direction to begin with.
85b7c7a9553c0ee1f2ba444c39e6e5af.png


Thanks very much in advance for any help.
 
Last edited:

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
That is going to require a macro. To help, can you specify the ranges the target data is going to be in and where the results should go, + anything else you think might be relevant.
 

BigBonna

New Member
Joined
Jan 27, 2014
Messages
20
That is going to require a macro. To help, can you specify the ranges the target data is going to be in and where the results should go, + anything else you think might be relevant.

Thank you for the reply.

I'm yet to make the spreadsheet, so I can put the data ranges anywhere. Ideally, I'd like the sorted tabular format to be on another sheet. For the sake of functionality, I'd put names in the A column, the first number in the B column and the 3rd in the C column. My B column data would be for the table's columns and the C for the rows - if that makes sense.

Forget about the extra data for now, those 3 are the most important ones.
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
Thanks for the extra info. vba's not really my tihng, but someone will no doubt wander past and pick this up...
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,315
Members
414,053
Latest member
Dual Showman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top