Converting 2 columns into multiple columns?

[tmarino]

I am at a complete loss here.....I have a few columns that I need to spread out and can't quite figure it out. Obviously, this data was not collected correctly from the get-go, but now I have to deal with getting it right.

Example:

COLUMN A COLUMN B COLUMN C
Bob Miles 650
Bob Miles 575
Jim Miles 685
Jim Miles 480
Bob Stops 7
Bob Stops 5


Is there a way to convert this to 3 new columns like below:

Name Miles Stops
Bob 650 7
Bob 575 5
Jim 685 0
Jim 480 0

I hope that makes sense and I really hope it is do-able - any suggestions??

 

[NeonRedSharpie]

It's very easy and doable. Only one question:

How are we assigning "Stops" to "Miles"? Is it Stops(1) = Miles(1) where name=name?

 

[tmarino]

My example got a bit jumbled. It is just an example of a much bigger spreadsheet I have where there are a lot of duplicate item "types" in Column B with attached values in Column C. I am looking to move all the duplicate info to new columns where the associated value is retained. So for example, The "Miles" value in Column B would become a new column called "Miles" and that column would be populated based on the corresponding values in Column C.

Man, this makes so much more sense in my head. I am more than happy to keep trying to explain it if I am still unclear and I REALLY appreciate any help!

 

[NeonRedSharpie]

So I understand your sample data, maybe my question wasn't clear, so let's try it with TABLES!

(I've had my coffee so watch out)


BEFORE

Name	Type	Value
Bob(1)	Miles(1)	650
Bob(2)	Miles(2)	757
Jim(1)	Miles(1)	685
Jim(2)	Miles(2)	480
Bob(1)	Stops(1)	7
Bob(2)	Stops(2)	5

<tbody>
</tbody>

Because you don't have a unique ID, I will need to create one on the assumption that the FIRST occurrence of Bob-Miles is aligned with the first occurrence of Bob-Stops.

 

[tmarino]

Yes - your assumption is correct!