Multiple Data Observations to Columns

J

Jimgaddis

New Member
Joined
Apr 19, 2013
Messages
1
Hi all;

I have a table of ~5,000 rows with 5 or 6 data items per unique index value, and need to 'distribute' the data items into columns so I end up with a single row for each unique index value. (database terms = normalizing). Can't figure out how in Excel, can you help?

Ex:
hospital 1 has 5 results, hospital 2 has 7 results, hospital 3 has 3 results, all in the same row. Need to end up with 1 row per hospital and a column for each observation (ED1, ED2, etc). See below and thanks!

10001SOUTHEAST ALABAMA MEDICAL CENTER1108 ROSS CLARK CIRCLEDOTHANAL36301HOUSTON3347938701ED1254306
10001SOUTHEAST ALABAMA MEDICAL CENTER1108 ROSS CLARK CIRCLEDOTHANAL36301HOUSTON3347938701ED268306
10001SOUTHEAST ALABAMA MEDICAL CENTER1108 ROSS CLARK CIRCLEDOTHANAL36301HOUSTON3347938701OP 18189628
10001SOUTHEAST ALABAMA MEDICAL CENTER1108 ROSS CLARK CIRCLEDOTHANAL36301HOUSTON3347938701Door to diagnostic eval66651
10001SOUTHEAST ALABAMA MEDICAL CENTER1108 ROSS CLARK CIRCLEDOTHANAL36301HOUSTON3347938701Median time to pain med10462
10001SOUTHEAST ALABAMA MEDICAL CENTER1108 ROSS CLARK CIRCLEDOTHANAL36301HOUSTON3347938701Head CT resultsToo few casesToo few cases
10001SOUTHEAST ALABAMA MEDICAL CENTER1108 ROSS CLARK CIRCLEDOTHANAL36301HOUSTON3347938701Left before being seen430663
10005MARSHALL MEDICAL CENTER SOUTH2505 U S HIGHWAY 431 NORTHBOAZAL35957MARSHALL2565938310ED1242664
10005MARSHALL MEDICAL CENTER SOUTH2505 U S HIGHWAY 431 NORTHBOAZAL35957MARSHALL2565938310ED265595
10005MARSHALL MEDICAL CENTER SOUTH2505 U S HIGHWAY 431 NORTHBOAZAL35957MARSHALL2565938310OP 18123723
10005MARSHALL MEDICAL CENTER SOUTH2505 U S HIGHWAY 431 NORTHBOAZAL35957MARSHALL2565938310Door to diagnostic eval35740
10005MARSHALL MEDICAL CENTER SOUTH2505 U S HIGHWAY 431 NORTHBOAZAL35957MARSHALL2565938310Median time to pain med79157
10005MARSHALL MEDICAL CENTER SOUTH2505 U S HIGHWAY 431 NORTHBOAZAL35957MARSHALL2565938310Head CT results3611

<tbody>
</tbody>
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

L
  • Question
Help Separating Address Data all in 1 Column
Replies
7
Views
355
Armando Montes
A

Forum statistics

Threads
1,214,611
Messages
6,120,509
Members
448,967
Latest member
screechyboy79

Share this page

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
Back
Top