Transpose

D

DonovanA

New Member
Joined
Jan 21, 2025
Messages
1
Office Version
  1. 365
Platform
  1. Windows

API
ProppantName
Total_Pumped

500110218​
100 Mesh
1223060​
500110218​
40/70 White
4899975​
500110534​
100 Mesh
365330​
500110534​
40/70 White
15725354​
500110535​
100 Mesh
309035​
500110535​
40/70 White
12328953​


Need to transpose like this

API
ProppantName
Total_Pumped
Propp 2
Total 2

500110218​
100 Mesh
1223060​
40/70 White
4899975​
500110534​
100 Mesh
365330​
40/70 White
15725354​
500110535​
100 Mesh
309035​
40/70 White
12328953​
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Sort by date Sort by votes
Hi & welcome to MrExcel.

How many distinct APIs are you likely to have?
 
Upvote 0
Forgot to ask, do you have the Groupby function yet?
 
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question Question
Sort X-Axis in PivotChart
Replies
2
Views
87
GraH
GraH
A
  • Solved
Countif question that looks at a tab reference
Replies
2
Views
63
arisomar
A
G
  • Solved
If Then else in Excel
Replies
9
Views
405
Gulfcourse
G
D
  • Question Question
Need help to solve this with a formula for drag and drop
Replies
3
Views
152
coulombevin
coulombevin
J
  • Question Question
Trying to add numbers when grouped together.
Replies
2
Views
101
jwillits
J

Forum statistics

Threads
1,226,089
Messages
6,188,839
Members
453,503
Latest member
MissVBAquery

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