In Excel, How do I turn Table A into Table B?
|
Post date: 2022-01-19 15:21:59 |
Views: 70 |
In Excel, how do I turn Table A into Table B?
I'm pretty sure it's something to do with PIvot tables but I can't figure it out (google sheet)
Table A
NameClothingColor
Johnshortsblue
johnhatred
frankshortsred
bobhat blue
Table B
NameShortsHat
johnbluered
frankred
bobblue |
Please click Here to read the full story. |
|
Other Top and Latest Questions: |
Movie: Spy x Family Code: White
|
Franklin: (all episodes)
|
TGI Fridays to go public through merger with its U.K. franchisee
|
Self-made millionaire who retired at 35: The first time I felt financially secure, I was 'living small' and spending 'a lot less'
|
Work is an infinite spiral of ennui and tedium. Someone help me.
|
Stocks making the biggest moves midday: UnitedHealth, SolarEdge, Bank of America, Tesla and more
|
If this is a stock market correction, here's how history says it will unfold
|
Lagarde says ECB will cut rates soon, barring any major surprises; notes 'extremely attentive' to oil
|
Healthy Returns: U.S. drug shortages reach record high, hitting Wegovy, ADHD medications
|
S&P 500 wavers, UnitedHealth lifts Dow: Live updates
|