Create a table from 3 columns

[EirlysA]

Hi.
I need help with the following. When I pull off a report and convert to excel it provides me with a list similar to below. The headings in column A wont appear for everyone, as they wont appear if that code wasn't used. I need a way to put this into a table, with states as the vertical, the names of the people as the horizontal, and the corresponding value in the table. Any help would be greatly appreciated

I have tried a pivot table, but it gives the sum, or count of, and I just need to return the raw data.

I have 25 names of people, and 26 states which each person could theoretically be in
ColumnA Column B Column C
Person Code Time in Code
Person A RC_Other 03:29:41
Person A 121 01:09:24
Person A Admin Work 01:12:35
Person A Break 01:27:53
Person A Comfort Break 00:51:14
Person A Emails 39:58:51
Person A Lunch 04:25:37
Person A Management Request 10:43:13
Person A Meeting 00:59:26
Person A Support and Coaching 01:01:03
Person A Technical Issue 00:06:11
Person A Outbound Call 00:00:30
Person A Challenging Call 00:04:25
Person A Call Wrap-Up 00:57:18
Person B RC_Other 01:28:01
Person B 121 00:00:06
Person B Admin Work 01:11:39
Person B Break 06:24:15
Person B Comfort Break 01:40:00
Person B Emails 50:27:08
Person B Lunch 09:34:59
Person B Management Request 02:28:48
Person B Support and Coaching 0:23:56
Person B Technical Issue 00:16:19
Person B White Mai l 00:48:04
Person B End of Shift 00:11:46
Person B Challenging Call 00:27:20
Person B Call Wrap-Up 08:35:23
Person B GP Allocation ACW 00:13:54

[sandy666]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[radddogg]

Hi

Please see attached.

I've achieved the results by adding a helper column to column D with the formula =A2&B2 to provide a unique identifier for the Person and Code.

The table is created on the sheet named Table with Code in A2 downward and Person in B1 across. It is then simply a case of using the formula =IFERROR(INDEX($C:$C,MATCH(G$1&$F2,$D:$D,0)),"") in cell B2 and dragging across and down.

You can simply paste your data into the Raw Data sheet and it will update the table. You'll obviously need to add the Persons and Codes to the Table and drag the formula.

Are you able to use VBA/macros? If so, you can automate this import and do loads of other funky things!

Give me a shout if you need any further help

Rob

ps I was born and raised in Redditch!

[EirlysA]

Radddogg - that was perfect thank you